how to get grand total values for MoM% and YoY% while using lookup or table calcuation
Hi, in my tableau viz i need to get the MoM% and YoY% for each row item and display grand total as well.
- I have tried using the quick table calculation of percent difference for MoM.
- I used the year over year growth from quick table calculation for YOY
Alternatively, i tried using the Lookup function to get the MoM% and YoY% as well. In both the approaches, the grand total value is blank. Can someone help me here.