How to add second KPI that shows year-over-year growth?

[leopatto]

I have a KPI button that shows net sales ($) that aggregates everything from 'net_sales' column next to I have a filter pane that can be drilled down from years>months>days. 

I would like the KPI button to show if someone clicks on the 2024-year filter pane, percentage as a number - to  show whether the money is up or down. 

My formula for pivot table is 

=(Sum(net_sales)/Above(Sum({<Year>}net_sales)) - 1) * Avg(1)

 and it's correct -- I just don't know how to add the same formula to the KPI button 😕 

Thank you in advance,

Leo

[Chanty4u]

Try this

=(Sum({<Year={$(=Max(Year)-1)}>} net_sales) - Sum({<Year={$(=Max(Year))}>} net_sales)) / Sum({<Year={$(=Max(Year)-1)}>} net_sales)