Set Analisys with max and total

[#1]

Hi all, i woud like show in a pivot table the last order of the season for each customer

The expression works well when I select the customer but when the customer is not selected the result is null

({1<  OTNUOR = {'$(=Max(OTNUOR))'}>} TOTAL<AANOCO> OTTSTA)

Many Thanks

Claudio

[lironbaram · Accepted solution]

attach is an example

[#3]

Many Thanks Liron

Works perfectly