Skip to main content

Hello All,
Could you help me to understand how to select recent 5 years in Pivot Table(New View). Currently i can see older data also like below.

I want to limit it to last 5 years only. Please help.

Regards,

Apurva

Hi, you can select years by clicking on relevant years and applying a filter like on screenshot below. 
 

 


Hi, you can select years by clicking on relevant years and applying a filter like on screenshot below. 
 

 

Hello Yevhen,

Thank you for the suggestion. However i want to show recent 5 years at same time. Above suggestion will obviously select only 1 year at a time.


If you click on each desired year and then press the green button, it will automatically select ALL selected years. In the example above, I selected two out of three quarters, and only the two I chose are displayed after I click green button.


Reply