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 to have its own 100%, and not the 100% of all the categories

Does anyone knows how to do it by Set Analisys?

Thanks

MAC

[dineshkumar]

hi martha,

   its actually showing in proper manner. if there is any sub category of your dimension it is possible , share your qvw.

[rubenmarin]

This question is duplicated (and possibly answered) here: Percentage calculation by Set Analysis

[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.