I would like to be able to set a filter on a hidden subtotal. In the attached workbook based off the superstore sample, we have Customer Segment, and then individual customer. What I'd like to see is the total sales by segment, but only include the amounts from within that segment where the total over Customer Name had over $1,000 in sales. I'd then like to remove customer name entirely from the sheet and only be left with the totals by Segment.
Sheet 2 has the filter I want, but I can't figure out how to have Customer Name be a hidden dimension. I tried a few of the windowing functions, but I haven't found a way to get them to work quite the way I want.
I think that was just a typo on your part.
Here's your solution. Simply drag Customer Name to the Detail shelf. Then use a WINDOW_SUM for your Label/Text shelf (in the pane), with the formula I gave previously. Last step is to go to the "Analysis" menu and turn off "Stacked Marks"
The attached is the result (in the "Detail View" sheet). Hope this helps.
