Forum Discussion
How to calculate variance ?
Hello,
I have table that looks like this:
I created matrix like this:
What i really need is matrics that has Variances which is 2021-2020 and also %YoY which would be Variance/2020.
So something like this:
| FiscalWeek | 2020 | 2021 | Variance | %YoY |
| Week-1 | 119 | 133 | 14 | 12% |
| Week-2 | 133 | 133 | 0 | 0% |
| Week-3 | 112 | 126 | 14 | 13% |
| Week-4 | 133 | 119 | -14 | -11% |
| Week-5 | 112 | 112 | 0 | 0% |
| Week-6 | 133 | 140 | 7 | 5% |
| Week-7 | 126 | 112 | -14 | -11% |
| Week-8 | 119 | 126 | 7 | 6% |
| Week-9 | 126 | 126 | 0 | 0% |
| Week-10 | 133 | 119 | -14 | -11% |
| Week-11 | 126 | 140 | 14 | 11% |
| Week-12 | 112 | 126 | 14 | 13% |
| Week-13 | 119 | 133 | 14 | 12% |
| Week-14 | 119 | 105 | -14 | -12% |
| Week-15 | 105 | 133 | 28 | 27% |
| Week-16 | 119 | 112 | -7 | -6% |
| Week-17 | 112 | 112 | 0 | 0% |
And ultimatelly i need to be able to grab data from 2020, 2021 and %YoY and plot it on the line chart.
Can this be done?
1 Reply
- v-angzheng-msft
Community Support
Hi, Anonymous
If you keep your data structure, then you can't get the above matrix effect, unless you pivot the year column, and then use a table to achieve such a visual effect.
Matrix:
Pivot the year column and use a table visual.
Please refer to the attachment below for details
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
