Forum Discussion
Comparison at group vs individual level
Hi, I would like to compare actuals vs targets at both individual and group level. For example, let's say my actual vs target data is: US = 50% vs 30% UK = 60% vs 60% Canada = 40% vs 50% e...
v-piga-msft
Resident Rockstar
Resident RockstarHi Anonymous,
For you scenario, more data sample would be better.
If it is convenien, please share some data sample which could reproduce your scenario and your desired output so that we could help further on it.
In addition, here is a similar thread you could refer to.
Best Regards,
Cherry
Hi Cherry,
Thanks for your response. I've attached some dummy data which may help:
https://www.dropbox.com/preview/Global%20vs%20Indiv%20Test.xlsx?role=personal
Desired output would be to view Actuals, Targets and the Variance over time through Country and Office slicers (including at the 'Global' and/or 'All Office' levels).