Thanks for the response.
I don't want to calculate in a chart. I want to show it as a KPI and at the same time when filter selections are made. it should change accordingly.
I have a year as a filter,
when two years are selected it should calculate as (CY-PY)/PY*100= % value
if more than 2 years are selected then it should calculate as a average as shown in the above
- When 3 years are selected
- Year one growth = $120,000 / $100,000 - 1 = 20%
- Year two growth = $135,000 / $120,000 - 1 = 12.5%
- Total as (20%+12.5%)/2 =16.1
Depending on the number of years selected the KPI overall value should change.