How to display null Value in bottom of the Pivot Table

[Lakshminarayanan_J]

Dear All,

I need to display the null value in the sub team @ the bottom of the pivot table ,i have tried out the sorting option but it is not working ,kindly help me out on this !!

Current Result

Business Unit	Sub Team	Brand
Total
YYYY		Total
YYYY		a
YYYY		b
YYYY		c
YYYY		d
YYYY	Bien-etre	Total
YYYY	Bien-etre	A
YYYY	Bien-etre	B
YYYY	Bien-etre	C
YYYY	Bien-etre	D

Expected Result

Business Unit	Sub Team	Brand
Total
YYYY	Bien-etre	Total
YYYY	Bien-etre	A
YYYY	Bien-etre	B
YYYY	Bien-etre	C
YYYY	Bien-etre	D
YYYY		Total
YYYY		a
YYYY		b
YYYY		c

[Lakshminarayanan_J]

Can you please help  me out on this above issue

[carg1]

Hi, 

can You make a screenshot of Your sorting options. 

BR

[Brett_Bleess]

Best I have that may be helpful is the following Design Blog post, and believe you will have to do an expression on this one...

https://community.qlik.com/t5/Qlik-Design-Blog/The-sortable-Aggr-function-is-finally-here/ba-p/14702...

Regards,
Brett