Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please have a look at the attached image.
I am using a table
I want to calculate the % of total sales of each category restarting every region
E.g
Region Product Sales Expected % of Total
1 A 10 16%
1 B 20 33%
1 C 30 50%
-----------------------------------------------
2 A 12 15%
2 B 16 20%
2 C 50 64%
Currently the total sales is calculated for all regions and all categories
How to resolve this
Maye be :
sum(Sales)/sum(total<Region> Sales)
Maye be :
sum(Sales)/sum(total<Region> Sales)