1 Reply Latest reply on Feb 14, 2020 4:01 AM by Philip Fernandez

    aggregates and no aggregates - sales by a criteria divided by total sales

    Philip Fernandez

      Hi,

       

      I am adding up sales for each year based on a criteria and then taking the total :-

       

       

      When I try to divide this by the SUM([Sales]) to get the % it wont let me as I get the "cant mix aggregates and non aggregates" error

       

      The individual sales calcs for each year are like this :-

       

      Where the set gets the top 10 sales for that year

       

      Is there a way to fix this so I can work out the %

       

      Thanks

      Phil