-
1. Re: Hide Categories w/o Changing Calculation
Michael Lance Oct 2, 2012 2:13 PM (in response to Michael Lance)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
Alex Kerin Oct 2, 2012 2:14 PM (in response to Michael Lance)1 of 1 people found this helpfulYou 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...
-
3. Re: Hide Categories w/o Changing Calculation
Alex Kerin Oct 2, 2012 2:22 PM (in response to Michael Lance)1 of 1 people found this helpful -
4. Re: Hide Categories w/o Changing Calculation
Alex Kerin Oct 2, 2012 2:21 PM (in response to Alex Kerin) -
5. Re: Hide Categories w/o Changing Calculation
Michael Lance Oct 3, 2012 6:58 AM (in response to Alex Kerin)Thanks!!!
-
6. Re: Hide Categories w/o Changing Calculation
Michael Lance Oct 3, 2012 12:13 PM (in response to Alex Kerin)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
Alex Kerin Oct 3, 2012 1:30 PM (in response to Michael Lance)1 of 1 people found this helpfulPut the real categories pill into the filter as well and exclude them.