Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to have my chart like this:
Hi Peter,
Please find attached demo file for your reference.
Regards,
Akshaya
Try to change your expressions like:
You would do this with the TOTAL function, so if your expression is sum(Value) percentage would be:
sum(Value) / sum(TOTAL Value)
Where the TOTAL causes the divisor to calculate across all dimensions. If you have two dimensions in your chart (say in a Pivot) you can do the total across a second dimension:
sum(Value) / sum(TOTAL <Dimension> Value)
If you want to ignore selections on a certain field (so you always look at the total, not the total of selected items) you can use set analysis to ignore some selections in the total:
sum(Value) / sum({<Dimension=}>} TOTAL Value).
After this, change the Presentation options of Bar chart.
Thanks for your response.
I wanted something like this:
I uploaded it, in case someone else needs it.