4 Replies Latest reply on Nov 5, 2010 11:22 AM by guest contributor

    Calculating  percentage totals on a table including measures that have been excluded from a filter

    . Kemi

      Maybe the best way to explain this is to offer an example:


      I have 4 values a,b,c,d... a percentage total on all 4 values will sum to 100%. if i filter out b, i want the percentage total to stay the same as it was for a,b,c,d...i can't simply hide b, because my grand total still shows 100% and i want it to show 75% (assuming even proportions).


      I hope this is clear...any ideas?


      thank you!