How to display null Value in bottom of the Pivot Table

[grajmca_sgp123]

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

[tealowk]

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

[udit_k]

[grajmca_sgp123 · Accepted solution]

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