topic Re: Show only last year data in pivot table in App Development

Show only last year data in pivot table

LP27 — Sat, 16 Nov 2024 20:00:11 GMT

Hi,

I have a date Field as - (Period) in format of 'MMM-YYYY' . I need to only show last year data(2018).

How do i go with the script.

For Example -

Now i need to show only last year column, ie. 2018

Note: Period Field has auto calendar applied.

Thanks in advance.

StarinieriG — Fri, 27 Sep 2019 07:37:46 GMT

Hi,

you could do it with set analysis, but if you want to do it with the script:

- you could create a new field year inside calendar like this if(year(period)=Year(Today())-1,Year(Period)

- then use this field in the pivot

LP27 — Fri, 27 Sep 2019 10:02:18 GMT

Thanks a alot! It worked.