bar chart

[upaliwije]

I have fllowing bar chart with two dimension. Namely Yera and Mode where there are two columns representing them . I want to show show both coloum with break up for 100%. Kindly help me this

[jwjackso]

If you want the columns to total 100%, you need to calculate the breakup as a ratio of the mode (assuming mode is either normal or "on the spot").

Something like this,

=Sum({<mode={'NORMAL'}>} breakup)/Sum({<mode={'NORMAL'}>} Total breakup)

Do this for both modes.  The stacked columns should total 100% of their mode.