Sort model based on latest week in pivot table

[Rajkumar]

Dear All,

Can anyone help me to sort model based on latest week in pivot table.

sample data:

week
Model w45    w44   w43   w42
M1           2         6                     5
M2         6                        5          4
M3                    1
M4        7         5            4
M5         8
M6                   5                            5

[Kushal_Chawda]

how your week is calculated?

[Rajkumar]

Week field ex. w1 to w 52

[lorenzoconforti · Accepted solution]

As your sorting expression use; see also attached file:

=aggr({<Week = {"$(=FirstSortedValue(Week, -aggr(num(replace(only(Week), 'w','')), Week)))"}>}sum(Value), Model)