Hi!
Okay, I have no idea how to make this happen - or if it's even
possible,
so I really need help on this one.
Mission: Change how the totals for the top level in a parent-child sum
up.
I have a physical four level parent-child structure that looks like
this:
Level A
Level B
Group
Account
And from a member point of view, it looks something like this:
(sorry about the generic layout; NDA)
Member A1
Member A1B1
Group A1B1G1
Account A1B1G1A1
Account A1B1G1A2
Account A1B1G1A3
Group A1B1G2
Account A1B1G2A1
Member A1B2
Group A1B2G1
Account A1B2G1A1
Account A1B2G1A2
Member A2
Member A2B1
Group A2B1G1
Account A2B1G1A1
Account A2B1G1A2
Member A2B2
Group A2B2G1
Account A2B2G2A1
Member A3
Member A3B1
Group A3B1G1
Account A3B1G1A1
Member A3B2
Group A3B2G1
Account A3B2G2A1
Account A3B2G2A2
.... and so forth.
At the top level (Level A) member A1, A2, and A3 now shows the
aggreagate
of whatever is below each member.
But what I'm trying to accomplish is more of a running total of Level A
where;
Member A1 = Member A1
Member A2 = Member A1 + Member A2
Member A3 = Member A1 + Member A2 + Member A3
Quote:
From what I've read in BOL, a custom rollup formula should be able to
solve this
|
when you want to change how a physical level is aggregated.
But how? lol
And the levels below Level A must remain intact.
Any help appreciated!
Thanks!
Tim