Hello,
I am working on creating a matrix where I want to show the actual value vs. target value over a period of time (say 2018 YTD). I have target values stored in an external file based on geographical hierarchy (i.e. Global target, continental targets, down to district-level targets). How do I dynamically change my measures for the actual and target based on the lowest level of selected geography in a slicer?
For example, if the user has selected USA, the table should show the actual vs. target for USA, vs if the user has selected North America.
Right now, my data is in a format where it has hierarchy down the the district level, but I want to be able to roll it up to a higher level. In addition, my targets are not rolled up targets of the geography below them. For example, the North America target may not be the average of the target for USA, Canada and Mexico.
