Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All
I need to display the null value in 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
here is the solution .
I have updated Dimension to: =if(IsNull(L1_OFB), '-', L1_OFB)
and Sort by expression =if(IsNull(L1_OFB), '-', L1_OFB)- descending
Hi Grajesh,
based on the information provided in your post I'd suggest that you add the following two lines to the beginning of your load script:
NullAsValue MyField;
Set NullValue = '99. Others';
This way, the Null values in the field MyField (replace by your field name) are displayed as '99. Others' and can thus be used for sorting.
Hope that helps.
Kind regards from Brussels,
Thilo
here is the solution .
I have updated Dimension to: =if(IsNull(L1_OFB), '-', L1_OFB)
and Sort by expression =if(IsNull(L1_OFB), '-', L1_OFB)- descending