• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. M

    Showing Row Header w/ No Data, w/o Detail

    Well, my goal is to show different pivots pulling from the same data set for multiple views, depending on whether the viewer is interested in the equivalent of "Sub-Sub-Head1" vs. "Sub-Sub-Head2." And, rather than having the equivalet of "Header 2" entirely missing from a pivot, simply showing...
  2. M

    Showing Row Header w/ No Data, w/o Detail

    Sure! Just uploaded the test file I used to show the screen grabs. First tab is a standard pivot with filter. Second is the same pivot, but with "Show items with no data" turned on.
  3. M

    Showing Row Header w/ No Data, w/o Detail

    This is a bit finicky. When I pull a pivot with filtration, I want to show all row headers, but maintain the filtration for details, and aggregate data. So, for instance, let's say I have the following data set: If I pull a pivot for this data set and filter only on "Sub-Sub-Head 1" for...
Back
Top