I want to get the ratio of total Store Sales ie 15.32M by each store sales. How can I get this division?
I tried putting the total Sales in a variable and then divided by using aggr function: Aggr(Sum(UNITS),STR_ACCOUNT_NAME_DESC).
I'm not getting the correct answer. I need it 15.32M/ Sales of store 1,Store 2 and so on in the table
Solved! Go to Solution.
try this !!!
Sum(Store Sales) /
Max(TOTAL Aggr(Sum(Store Sales),STR_ACCOUNT_NAME_DESC) ))
Max(TOTAL Aggr(Sum(Store Sales),STR_ACCOUNT_NAME_DESC) ))/Sum(Store Sales)
Did you mark you own answer as correct by mistake .
I would suggest marking the response which is actually correct, so that future users can find it useful when they land on this page.