Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have created a pivot table and i need to calculate (sum of sales for selected month - sum of sales for previous month of selected month) for 3 months based on user selection
try :
sum({<Date,Month={"<=$(=max(Month))>=$(=max(Month)-2)"}>}Value)
or
sum({<Month,Date={"<=$(=max(Date))>=$(=MonthStart(addmonths(max(Date),-2)))"}>}Value)