One of the new feature of 11g is the AGGREGATE AT function. It uses the hierarchical level to pin the the aggregate. Problem is you can’t select a hierarchy level in the formula editor, so you have to some old school typing:
Only month 1 to 6 are selected.
Just like the BY statement you can do multiple levels from different Hierarchies:
Go to Source