Hi Rajesh,
Not sure why the sorting did not work. On the first click the button will sort the bars in descending order, when clicked again – ascending order, third click will return the bars to natural order. Please send us the file if you wish someone to look into this.
Thanks

Hi Rajesh,
The answer is – this behaviour is deliberate, rather than a bug.
Stacking of split values delivers meaning in a cumulative sum situation, when you want to see individual contribution of each category to the overall total.
If you choose Mean – mean of each split (in statistics) should be a weighted mean of individual stacks, rather than a sum of their individual means…
Information would be lost in stacking and result would be misleading… Similar goes for other functions .

Hi Paola,
I have convinced the Client that if we stack the data with different column the sorting will get disturbed.

Thanks for your help.

Regards
Rajesh B