1 Reply Latest reply on Jun 30, 2016 9:34 AM by John Sobczak

    Grand total for separate categories.

    Seona Joung

      I have a table that shows counts and percentages of two categories - i will call them cat 1 and cat 2. These two categories are grouped by codes.

      So code 1 has a group 1 and 2, code 2 also has corresponding group 1 and 2 and display counts and percentages in columns.

       

      When I add grand total at the bottom of the chart, the percentage ends up becoming 200% as each category is 100% respectively. Is there a way show grand total of each category without having to using filter?