Calculate percentage of total for each month

[bharatkishore]

Hi All,

I have a combo chart with two dimensions. One is for month year and category.

The expression what i have written is :

sum(IB)/sum(TOTAL<[Month-Year]> IB)

This expression is working fine at over all level. But when i filter category, the numbers are changing to 100%.

Can you please tell me where i am doing wrong

Thanks,

Bharat

[tresesco · Accepted solution]

If you want to check category% on selection of them, try like:

sum(IB)/sum(TOTAL<[Month-Year]> {<Category>} IB)

[bharatkishore]

Thank you so much.

I have given like

sum(IB)/sum(TOTAL<[Month-Year],cat> IB).. But it didn't work.

Can you please tell mw diff between the two expressions.

[tresesco]

Category in your expression would be considered to ignore the chart dimension members (in this case: both the dimensions mentioned in total scope is equivalent to mentioning no 'total'). Whereas, in my expression, category dimension selection is ignored to calculate the total (to be used as denominator).

[bharatkishore]

Thank you for your reply..got it now.. thanks a lot..