Hi I am trying to achieve
-14.6% cell formula = (YTD Actuals /ytd budget)-1
1.4% cell formula = (ytd actuals/last year)-1
I tried using look up but I am getting below results
4 answers
Instead of using a LOOKUP, you can structure your data differently and create a LOD calculation (Overview: Level of Detail Expressions - Tableau )
CASE [Data]
WHEN "Actual" THEN NULL
WHEN "Actual Last Year" THEN ({ SUM([YTD Actuals]) } / { SUM([YTD Last Year ]) }) - 1
WHEN "Budget" THEN ({ SUM([YTD Actuals]) } / { SUM([YTD Budget])}) - 1
END
