Previous value of financial year

[Neha121]

Hi ,

    if the table has below in the current Year, how Do I calculate the prior year for chart

Formula for current year is sum(counter)

[Amit_Prajapati]

Share the clear requirement.

Do you want a previous year column as below 

Current , Previous Year 

2025-2026 , 2024-2025

2024-2025,2024-2023

based on above you also have to show trends right ?