Adding column in pivot table for 1 year view

[deepakqlikview_123]

Hi all,

PFA.

I have attached the app.Now I need column for >1 year selection in 1 year drop down selection so that I will get previous 12 months and data for > 1 year column.

Rest is as per required.

PS data for total in >1 year column  in 1 year view and total in >1 year drop down view should match

Thanks

[deepakqlikview_123]

Hi All,

Can you please suggest on this.

Thanks