Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Please try:
Sum( {<SalesYear={'$(=year(max(SalesYear))-1)'}>} SalesAmount )
@rp1366nc If you have year as dimension set analysis won't work. You need to use above function
=above(sum(SalesAmount))