Stacked Bar Chart

[Anonymous]

I want to have my chart like this:

[adityaakshaya]

Hi Peter,

Please find attached demo file for your reference.

Regards,

Akshaya

[balabhaskarqlik]

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.

[Anonymous · Accepted solution]

Thanks for your response.

I wanted  something like this:

[Anonymous]

I uploaded it, in case someone else needs it.