I am trying to create a new calculated member within a dimension and am looking for help to get me through..
I have a dimension that has been created as a hierarchy from Region > Country. What I want is to create a calculated member at the Country level for each member of the Region level. I have attached a sample workbook with the data that I was playing with. On the attached sheet, I would be looking to create a member within Europe.
Has anyone done this before? Can you help me please?
The only way to add a member to the Region/Country fields would be to add it to your original data source.