2 Replies Latest reply: Apr 4, 2013 4:38 PM by Steve Zagzebski RSS

    Aggr small amounts

    Steve Zagzebski

      I want to aggragate products that have had sales less than a certain amount into one bucket in a chart.

       

      Ex.

       

      Sales of Product A - 50

      Sales of Product B - 60

      Sales of Product C - 70

      Sales of Product D - 80

      Sales of Product E - 1

      Sales of Product F - 2

       

      How would I write a calculated dimension that would group any product with sales under 10 into one combined product and if it is over 10 they just remain the same?

       

      The results in the chart:

       

      Sales of Product A - 50

      Sales of Product B - 60

      Sales of Product C - 70

      Sales of Product D - 80

      Sales of Combined Products < 10 - 3