YoY Growth in Table Chart

[rp1366nc]

I have try to create a YoY Growth in a table chart.

I try a expression to get the previous year value:

Sum( {<SalesYear=${year(SalesYear)-1}>} SalesAmount )

But the value have no change which same as the current value.

May I know what is the problems?

Thank you.

[rupeshshah888]

Please try:

Sum( {<SalesYear={'$(=year(max(SalesYear))-1)'}>} SalesAmount )

[Kushal_Chawda]

@rp1366nc  If you have year as dimension set analysis won't work. You need to use above function

=above(sum(SalesAmount))