Percentage calculation by Set Analysis

[#1]

I have this

And the Mesure is calculated by

Sum(SaleAmount)/SUM(total SaleAmount)

But what I really want is that each category has its own 100%, and not the 100% of all the categories

Does anyone knows how to do it by Set Analisys?

Thanks

MAC

[rubenmarin]

Hi Martha, if the x-axis dimension is 'Category' you can use this expression:

Sum(SaleAmount)/SUM(total <Category> SaleAmount)

[jagan]

Hi,

Check this expression

Sum(SaleAmount)/SUM(TOTAL <Category> SaleAmount)

Note: Replace Category with your actual field name.

Hope this helps you.

Regards,

Jagan.