Been quite some time since I have been here. Thought I would see if you guys have a reference to something you have probably answered before.
I need to do a formula to do a common size (percent of total) calculation except on the grandparent groupby summary.
Something like this pseudo code AColumnAmount / GrandParent:Sum(AColumnAmount)
Thanks for any help you might reference me too!
Nick
Hi Nick,
I'm not entirely sure exactly what you want. Can you explain in more detail or maybe provide a sample or some screen shots?
In accounting they call it a common size calculation. It's a % of a total. However in this case it's a % of a total of totals.
Hope this makes it a little clearer.
Thanks,
Group: Ops