Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a Pivot table where i want to display last 30 days data by default.
I also want to be able to have a filter with date fiield and should be able to view previous data when filter is selected.
Please help.
Thanks,
Monu
Try like this .
Sum({<Date = {">=$(=Addmonths(Max(Date),-1))"}>}Value_Field)