Set Analysis - Date

[shamitshah]

Hi,

Please see attached file.

I am trying to get Column B to be the selected date-2, but I am not getting any figures.

I have the expression as

=Sum({<SalesDate={"$(=Max(SalesDate)-2)"}>}Sales)

Column A works fine.

Any ideas?

Thanks

Shamit

[Kushal_Chawda · Accepted solution]

Just provide Date format to your expression

=Sum({<SalesDate={"$(=date(Max(SalesDate)-2,'DD-MM-YYYY'))"}>}Sales)

[shamitshah]

Kushal

Thanks! Works perfectly.

Shamit