Skip to main content

Limit the row level data in Pivot(New View)

  • August 18, 2025
  • 3 replies
  • 33 views

apurva.patha12
Level 6
Forum|alt.badge.img

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

3 replies

yevhen.riabt12
Level 3
Forum|alt.badge.img
  • Level 3
  • 3 replies
  • August 25, 2025

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

 


apurva.patha12
Level 6
Forum|alt.badge.img
  • Author
  • Level 6
  • 16 replies
  • August 25, 2025

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.


yevhen.riabt12
Level 3
Forum|alt.badge.img
  • Level 3
  • 3 replies
  • August 25, 2025

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.