6 Replies Latest reply: Nov 29, 2016 4:58 PM by Seth Rosenbauer RSS

    Suppress when value is null chart issue

    Seth Rosenbauer

      Is it possible to suppress a dimension when the value is null and have an expression that calulates a percentage and the total of that percentage adds up to 100.

       

      See the example below.

       

      PersonSales% of Total Sales
      Sam 1010%
      John2525%
      Mark5050%
      TOTAL8585% instead of 100%

       

      --in this example, there are 15 sales that are 'null' and I don't want to include. However, I still want the % to add up to 100 when I suppress null values