Forum Discussion
Junaid11
Helper V
3 years agoVariance based on Category and Period
Hello,
I have a table which look like below:
| Period | Category | Sales |
| 1 | Apple | 9235 |
| 1 | Orange | 3461 |
| 1 | Banana | 376 |
| 2 | Apple | 1257 |
| 2 | Orange | 3562 |
| 2 | Banana | 8093 |
| 3 | Apple | 961 |
| 3 | Orange | 468 |
| 3 | Banana | 236 |
I want to do the variance among categories based on Period. For example in slicer of period if I choose Period 1 and Period 2 the variance should be shown against the category as shown in the picture below:
| Apple | 7978 |
| Orange | -101 |
| Banana | -7717 |
Similarly If I choose the slicer 1 and 3 the ourcome would be the variance between both the periods as below:
| Apple | 8274 |
| Orange | 2993 |
| Banana | 140 |
I just want the variance to filter automatically between the two selection made in the slicer.
Your help would be highly appreciated.
Thank you
1 Reply
- CNENFRNL
Community Champion