Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.