1 Reply Latest reply on Mar 3, 2017 12:03 PM by Mia Lee

    Customizing grand total percentage

    Seona Joung

      I have two dimensions in row and column section and two measures - counts and percentages.

      I want to show column grand total for percentage to be always 100% without changing the percentage that show correctly across the row. Is this possible to do?

        • 1. Re: Customizing grand total percentage
          Mia Lee

          Hi, Seona

           

          The measure percentages don't add up to 100% but you want the grand total to be 100%? If your percentages don't add up to 100% because of the filters you use, you can rightclick and "hide" instead of filtering the data out - that will keep the grandtotal 100%.

           

          Hope this helped.

          Thanks,

           

          Mia