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



      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 %