Sorting in a pivot table by last column

[Marlen]

Hello again.

I'm trying to sort my pivot table by last column (desc). Columns as monthes:

count({<[MonthFiled]={$(=max([MonthFiled]))}>} 1)

in sort by expression

but it's incorrect. [MonthFiled] is numeric - first date of each month.

What am I doing wrong?

[morgankejerhag]

If MonthFiled is a date you will have a problem comparing the value with max in set analysis. This is due to that max() will return the integer form of the date (45324) while the comparison is made with the text 2021-02-13. You need to change the value to date after the max.

count({<[MonthFiled]={$(=date(max([MonthFiled]),'YYYY-MM-DD'))}>} 1)

The format of the date needs to match the format of MonthFiles.

Morgan Kejerhag
Senior Business Intelligence Consultant
Drake Analytics
http://www.drakeanalytics.se