Help in set analysis

[#1]

Hello Friends,

As I am trying to fine the sum of sales for the maxium year.

I tried the following but it throws a error.

=Sum({<ShipmentYear={'$(=max(ShipmentYear))'>}}[Sales])

Could you please help me..

Regards

Chriss

[Gysbert_Wassenaar · Accepted solution]

Just a typo it seems. Try:

=Sum({<ShipmentYear={'$(=max(ShipmentYear))'}>}[Sales])

[#3]

Hello Gysbert,

Thanks a lot, it works, I tried this for the past 2 hours, came with a good solution.

Reagrds

Chriss