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...
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.
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...