Hi All,
I have created 2 side-by-side linked (the reports share the same axis) Income Statement reports in BPC. How do I add a 3rd report which will calculate the variance between these 2 existing reports. I think I would need to create a local member as the 2 reports are going to be dynamic across time and regions. Eg. I have 2013 & 2014 for EMEA - 15 entities, if I change the region from EMEA to Americas with 25 entities, I want the variance for all the 25 entities now instead of the previous 15. I also want the variance to show the drill down if I click on one of the reports to find the child members if they exist.
Any pointers?
Thanks!