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

    Hide Categories w/o Changing Calculation

    Michael Lance



      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,