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

# Hide Categories w/o Changing Calculation

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

• ###### 1. Re: Hide Categories w/o Changing Calculation

Also, if I could display the percentage with the numerator and denominator over it (or somehow on hovering over), that would be even better!

• ###### 2. Re: Hide Categories w/o Changing Calculation

You could handle this by hiding the others, but it's not very dynamic:

The other way to do this is a filter that uses a table calculation - the table calc filter is applied after the sum percent calc,so the % remains correct.

Create a calc field:

lookup(attr([Fc Rc Elpa],0)

and drag this to the filter and select whoever you want to.

This table calc basically looks up the FC Rc on the same row (0), so while a table calc, does absolutely nothing...

1 of 1 people found this helpful
• ###### 3. Re: Hide Categories w/o Changing Calculation

Read the last post first...

And:

total is: total(sum([Number of Records]))

1 of 1 people found this helpful
• ###### 4. Re: Hide Categories w/o Changing Calculation

You could drag these to the level of detail for them to appear in the tooltip:

• ###### 5. Re: Hide Categories w/o Changing Calculation

Thanks!!!

• ###### 6. Re: Hide Categories w/o Changing Calculation

What if I wanted to exclude categories like "NA" or nulls from the total calculation in this context?

• ###### 7. Re: Hide Categories w/o Changing Calculation

Put the real categories pill into the filter as well and exclude them.

1 of 1 people found this helpful