Display Last 30 days data

sarasmonu — Mon, 09 Apr 2018 03:23:54 GMT

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

Re: Display Last 30 days data

swarnendu — Mon, 09 Apr 2018 04:12:43 GMT

Try like this .

Sum({<Date = {">=$(=Addmonths(Max(Date),-1))"}>}Value_Field)