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
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.