Show only last year data in pivot table

[LP27]

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 - 

Name	2019	2018	2017	2016	2015
List	-	4
Top		6

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

Note: Period Field has auto calendar applied.

Thanks in advance.

[StarinieriG · Accepted solution]

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]

Thanks a alot! It worked.