Sorting a column

[Anonymous]

Hi,

How do I sort the column with the blue arrow (preference to descending):

[sibin_jacob · Accepted solution]

Go to Sorting tab.

Then Select Country -> the select sort by expression option.

For example your expression is Sum(Sales), then write the below expression in sorting tab.

I am assuming you need to sort table order based on Review Type Null

Sum({<Review_Type-={"*"}>} Sales)

Then select Decending Order.

If you need to sort based on Review Type 'No Owner', the sort tab expression will be

Sum({<Review_Type={'No Owner'}>} Sales)

Dynamic sorting is not available in Pivot table, which is available only in Straight table.

[Anonymous]

It works, Tnx!