I have this
And the Mesure is calculated by
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?
Hi Martha, if the x-axis dimension is 'Category' you can use this expression:
Sum(SaleAmount)/SUM(total <Category> SaleAmount)
Check this expression
Sum(SaleAmount)/SUM(TOTAL <Category> SaleAmount)
Note: Replace Category with your actual field name.
Hope this helps you.
Retrieving data ...