Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please help me with the expression to calculate past 3 months total sales in straight table.
How your data model looks like? How is the date stored?
Tough to say without knowing anything, But as assumption you may need
Sum({<Month = {">=$(=AddMonths(Max(Month), -3))<=$(=Max(Month))"}>} Sales)
try
Sum({<DateField={"<=Today()-3"}>}Sales)