Sorting in a chart (with drill down)

[newqlik2017]

Hello,

  Here's my data set. On my chart I have a dimension as a cyclic drill down and am looking to sort the dimension columns (Unit & Status) both on ascending order except the Misc value should always be the last row.  A sample QVW is attached for your reference. Suggestions, please?

Unit	Status	Amount
Agriculture	All	50
Agriculture	Misc	200
Agriculture	None	100
Financial	All	200
Financial	None	250
Misc	Misc	1000
School	All	100
School	Misc	250
Technology	None	500

Correct dimension sorting order (Misc value always needs to be at the last row):

Unit	Amount
Agriculture	350
Financial	450
School	350
Technology	500
Misc	1000

Incorrect dimension sorting order (Misc value always needs to be at the last row): So the order should be All, None, Misc):  

Status	Amount
All	350
Misc	1450
None	850

[sunny_talwar · Accepted solution]

Sort the order of the dimensions within the Group itself

[newqlik2017]

Works perfect, thank you.

I also have another question, may be you could help

https://community.qlik.com/message/1439884#1439884

Retain default view of the chart when toggling between tabs