4 Replies Latest reply on Oct 25, 2016 10:46 AM by Joe Oppelt

    Keep Overall Total denominator the same when filtering

    Colin White

      I am trying to show a percent of "overall total" one-liner in my cross-tab, so I can use it for a chart.  What I want is for this....

       

                  2000     2001     2002

      Y            30        35          15

      N            10        40          12

      Total       40        75          27

       

      ... to show as this...

       

                  2000     2001     2002

      Y          75%      46%       55%

       

      The problem I face is when I filter out the N row the Overall Total count reduces making my Y row show up as 100%.