I have a worksheet where we have used the 'hide' field to hide the data but only show the subtotals and grand totals.
However when you change the view through a parameter (changing quarters or years) then the hidden data
Is there a way to prevent the data from re appearing?
In the attached file, you see the column that shows 'totals'. Each row total had a set of individual data points
that added up to the sub total.
When you change the parameters, such as year and quarter, the new view comes up with
all the sub total underlying data.
So is there a way to prevent this?