@DylanM Thank you for the reply and I do not need to caculate WoW total for all metrics. I use ‘Add table calculation’ and select the difference of last two weeks for each metrics to avoid multi calculations. And for 6 month Avg, I create separate calculation field for each metrics.
So it seems like if I did not unpivot the data, there is no solution to create one single 6 month Avg calculation.
Here are all my questions and my current solutions for that: Quicksight questions
Thank you for taking your time to look into my questions