Sales comparision

[#1]

Hello,

i want to create a sales comparision of years. I have the table with the columns company,  year (2014-2017) and the sales amount.

Now i want to create a KPI dashboard which shows me the percentage of the change of the sales amount from the last to the year i select in the listbox.

Could someone help me and give me a formula for that? I have not found anything fitting to this issue now.

Thanks!

[sunny_talwar]

May be like this

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

[sunny_talwar]

Or may be this

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

[#4]

It doesn´t work for the year i pick in the list box. It just stays the maximum year

[sunny_talwar]

Would you be able to share a sample where it is doing this? I would love to see if Max(Year) doesn't change with selections