pivot table sort issues

[alexpanjhc]

I have a pivot table with 5 dimensions and 4 expressions.

one of the expressions are max(Days Open]). I want to sort by that only based on the last date (8/8/2017) but it does not seem to be working.

I tried to use aggr(max([days open], max(loadDate)) in all the dimensions .

Can you please help?

thanks!

[vishsaggi]

I doubt you can use something like

Aggr(Max(OpenDays), Max(LoadDate), ....)

May be try like:

= Aggr(Max({<LoadDate = {"$(= Date(Max(LoadDate)))"} >} OpenDays), Max(LoadDate), EMP_Name...)

[alexpanjhc]

Thanks for your reply, Vishwarath, but it is still not sorting it correctly.

[vishsaggi]

Is it possible to share some sample data to look into?