Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
=(Sum({<Year={$(=Max(Year)-1)}>} net_sales) - Sum({<Year={$(=Max(Year))}>} net_sales)) / Sum({<Year={$(=Max(Year)-1)}>} net_sales)