how to replace NULL value as top most value in pivot table?

[#1]

Hi,

Can anyone suggest me how can I get the replaced NULL value as top most value in pivot table? please see attached. As I replaced the Null Values with 'Not Default UTD' . I would need this at the starting of the column values.

Thanks.

[#2]

Thanks. what is input order means Is it load order? under sort tab?

[antoniotiman]

Try to use Rank function in Order Section

[#4]

Sorry I confused here. where is the order section? Is it Sort tab in pivot table?

[antoniotiman]

Sorry (Italian is Order), Sort section of Document.

[#6]

Thanks. How to use Rank function?

[antoniotiman]

Rank(Sum(Sales)) or Rank(Count(Customer)) etc.

for parameters  as Rank(sum(Sales),4) see Guide.

[eduardo_sommer]

Yes. It's the Sort tab. Move AgeSummary_March to the top of the list and choose Load Order.

[#9]

Thanks. Perfect