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
Hello Nick,
There are different approaches to solve this task. I made small sample with one of these solutions. Please take a look at the attached sample for more details and let me know if you have any questions.
Regrads
Hi,
If you need any additional assistance with this case feel free to contact me.
Regards
This is the sample