Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have above chart region wise. I want it should show % so I used "relative" tick mark. but it takes sum of all data regionwise.
i.e. =5154+2319+1046+733
I want first region should be calculated by 5154 ( divisor should 5154)
for 2nd 2319
so on..
please help me on this.
Narendra, For me question is not clear. Will you able to explain little more
Hi,
What are the dimension you have used?
You will need to use the expression to get the % instead of the Relative Option.
Regards,
Kaushik Solanki
Assuming you have the following
Dimensions
Dim1
Dim2
Expression
Sum(Measure)
You can try this expression
Sum(Measure)/Sum(TOTAL <Dim1> Measure)