2 Replies Latest reply on Sep 19, 2016 8:22 AM by Joe Oppelt

    Hide as a filter

    Santiago Calvo

      Hi everyone,


      I´m wondering if there is any way to hide and unhide in a similar way that we exclude or include with filters


      For example, if I have my country separate by department, once applied the filter to have only Montevideo and canelones, the percentage change from 42% and 16% (from the total of the country) to 73% and 27% (from the total of the included values, that are only those two)

      If I hide all but Montevideo and Canelones the percentages keeps being 42% and 16%, that´s what I want

      Is there any way to choose which departements to hide or unhide in an easy way like this


      Thank you!

        • 1. Re: Hide as a filter
          David Li

          Hi Santiago! You can do this using LOD calculations. For instance, maybe something like:

          { FIXED [Departamento] : SUM([Value]) } / { SUM([Value]) }

          This will calculate the % contribution of each department relative to the total in the context. If you filter, the number will stay the same, because the calculation is done at the record level.


          Note, however, that context filters will affect this calculation, and you may have to set some of your filters to context filters to get it to work properly.

          1 of 1 people found this helpful
          • 2. Re: Hide as a filter
            Joe Oppelt

            If you use a table calc as a filter, it will filter out what to DISPLAY, but not filter out what gets computed across the whole table.


            LOOKUP is a good way to do this.


            I don't have your workbook to test out the exact syntax, but it will look something like this:






            Put that on the filter shelf, and display the filter.  (You might have to edit the table calc to do TABLE(down) so that it looks down your list instead of across.)

            1 of 1 people found this helpful