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 %
Change your calculation as below by adding sum()
Hope this helps
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...