
Re: Calculating Share
Stefan WÃ¼hl Jan 27, 2012 8:00 AM (in response to misystem)If you have two dimensions, Category and Brand, and your sales field is called Sales, I think it's just
=sum( Sales) / sum(total<Category> Sales)
as expression, i.e. you just need an appropriate total qualifier with dimension list. Please check also the Help.
Then you could format the share e.g in number tab as percentage.
Regards,
Stefan

Calculating Share
misystem Jan 27, 2012 8:24 AM (in response to Stefan WÃ¼hl )Yes , also , i have a yaxis value as well or a column dimension , which is Branch , and the formula above would only give me the share of the sales of one dimension over the total of the other , but it would not give me the share depending on the yaxis dimension . i should've clarified it better .

Calculating Share
Stefan WÃ¼hl Jan 27, 2012 8:56 AM (in response to misystem)Maybe an example would help me to understand  it's still a bit unclear to me, but I still think the total qualifier should be the one here,
either try
=sum(Sales) / sum(total<Category, Branch> Sales)
or
=sum(Sales) / sum(total<Branch> Sales)
just include in the total qualifier field list all dimensions that you need to group by.

