I have a table with "quarters" as the column and row as "product family". Measure Value is the sum of underlying data - SUM(Total Price). However, when I tried to use the quick table calculation, the "YoY Growth" button grey out.
Is there any alternative way to add "YoY Growth Rate" to the table? Thanks!
CategoryQ1 2013Q2 2013Product Family 1Sum (Total Price)Sum (Total Price)Product Family 2Sum (Total Price)Sum (Total Price)
2 answers
Hi Daisy,
If I am understanding your question correctly, I would suggest using Level of Detail calculations to accomplish what you are looking for.
I am including the link below (c/o "Tableau Tip Tuesday") that should be a good resource for you.
Let me know if this is what you are looking for and if it helps you.
Best,
John
Tableau Tip Tuesday: Using LOD Calcs for Year over Year Comparisons
