Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to find percentage that percentage of sales of particular product out of total country sales
A - Country
B- Sales
I have used the following expression
aggr(sum(Sales),A,B)/aggr(sum(Sales),A)
Both of them are normal dimensions (not calculated)
I have attached excel of pivot the expression
B is product type not sales