Hi,
I would like to reproduce the following table, but I can't figure out how to get a column for a quick table calculation (in this case YoY growth) alongside the columns for measure names/values.
Hello Jonathan,
You can use the table calculation as below to calculate the YOY Growth
Ex: (ZN(LOOKUP(SUM(sales),-2))-ZN(LOOKUP(SUM(sales),-1))) / (ZN(LOOKUP(SUM(sales),-1)))
Compute the above sample calculation to Table Across.
Please let me know in case of any issues. Please mark the answer as helpful and correct if it resolves your question.
Thanks!Sankar M
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.