7 Replies Latest reply on Oct 3, 2012 1:30 PM by Alex Kerin

    Hide Categories w/o Changing Calculation

    Michael Lance

      Hello.

       

      Using the attached data set and sample workbook, I am attempting to create a table which displays only "Adv. Profic." (a category of the field: Fc Rc Elpa) and hides all other categories.

       

      I need the table to display the percent of "Adv. Profic." in relation the total. Currently, when I filter out the other categories, the calculation is impacted (not surprisingly). Do I need to make a parameter or something else to preserve the correct calculation while hiding the rest of the categories?

       

      Thanks in advance,

      Michael