Expression to calculate past 3 months sale in straight table

[dsdeepak284]

Please help me with the expression to calculate past 3 months total sales in straight table.

[Miguel_Angel_Baeyens]

How your data model looks like? How is the date stored?

[Anil_Babu_Samineni]

Tough to say without knowing anything, But as assumption you may need

Sum({<Month = {">=$(=AddMonths(Max(Month), -3))<=$(=Max(Month))"}>} Sales)

[zebhashmi]

try

Sum({<DateField={"<=Today()-3"}>}Sales)