I have a Region field with values ML,TW, HK and null (due to join condition).Now in the table I have added the dimension.I want to sort the data as ML,TW,HK and Null .
Could some one healp me in this please..
Thanks in advance.
You could use something like this in your Sort dialog expression:
=If(IsNull(Region), 4, Match(Region, 'ML', 'TW', 'HK'))
Hope that helps
Thanks for the reply but it is not working
=Aggr(If(IsNull(Region), 4, Match(Region, 'ML', 'TW', 'HK')), Region)
I have tried that as well but it is not working. Just for ur info I also have threee more field in the dimensions and some 5 expressions in the pivot table??
Is there any issue with the null values sorting in pivot table??
properties of chart--> sort --> check load order and uncheck other
See the link
hope it helps
Retrieving data ...