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:
Example:
Only month 1 to 6 are selected.
Just like the BY statement you can do multiple levels from different Hierarchies:
obieefans.com
Author:John Minkjan
Go to Source
