Anyone know how to do multi-group roll-ups?
Example:
Events Happen daily.
Events Happen During Morning, Noon, Night
People Do the events
People Report to people.
I have a drill down that shows: People reporting to people, the bottom person's events grouped and drilled to the day.
I want to have a sum of the events throughout the hierarchy.
Example data would look like:
Bob
Did Something - 150 Times
Did Something Else 300 Times
Carol (who reports to bob)
Did something 75 times
Did something else 200 times
John (who also reports to bob)
Did something 75 times
Did smeothing else 100 times
Bob gets Carol and John's sums.
underlying data looks something like:
Bob (all nulls)
Carol (Listing of data) (parent Id of bob)
John (listing of data) (parent Id of bob)
I'm able to get counts recursively, at each level, but not sub grouped (events)
Any help is appreciated
Cheers
Example:
Events Happen daily.
Events Happen During Morning, Noon, Night
People Do the events
People Report to people.
I have a drill down that shows: People reporting to people, the bottom person's events grouped and drilled to the day.
I want to have a sum of the events throughout the hierarchy.
Example data would look like:
Bob
Did Something - 150 Times
Did Something Else 300 Times
Carol (who reports to bob)
Did something 75 times
Did something else 200 times
John (who also reports to bob)
Did something 75 times
Did smeothing else 100 times
Bob gets Carol and John's sums.
underlying data looks something like:
Bob (all nulls)
Carol (Listing of data) (parent Id of bob)
John (listing of data) (parent Id of bob)
I'm able to get counts recursively, at each level, but not sub grouped (events)
Any help is appreciated
Cheers