Hi All,
Am trying to select one of the levels of my geography hierarchy as default value when the sheet opens, so that all the children are also selected.
I'm managed to use the actions on OnOpen to correctly choose the value 'Global' from the hieratchy, but this only selects this individual node, and not those below it. (the 'Current Selections shows HIERARCHYGEOG = Global). However, if I select the 'Global' element manually in the sheet, the Current selections changes to show HIERARCHYGEOG = 72427 of 72458, indicating that all the children of Global are selected (global does have some siblings I need to get rid of that accounts for the discrepancy).
What should I be using in my trigger to select all the children of this node too?
Just to clarify, having 'Global' selected is getting me the total values I want, but I'm using the children to provide a breakdown of paths relative to the 'Global' node.
Thanks!
Rory.
