1 Reply Latest reply on Jul 27, 2016 3:44 PM by diego.medrano

    Hidden data unhides when changing a view

    Dick Sobel

      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

      re appears.

       

      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?

       

      Richard