percentages struggle

[tonyvee1973]

Hi All

Trying to show percentages for products within a group.
In the screenshot below in the "A" section I need to see what percentage that product sales is of the total group sales.
Also need to see in "B" the group percentage to all total sales.
Can anyone help? Think I'm struggling at the group total is obviously a sum of all the products below.

 

[HowardHammerman]

Are the A products in our group and the B products in another? Are A & B a sub-group of group 1 (that is, group 2)?
If so, sum the sales at the group 2 level and create a formula that divided the value by the subtotal.

I bet it is more complicated, right?

Howard Hammerman,
Crystal Training and Crystal Material
On-site classes and one-on-one coaching
Low-cost telephone/email support

http://www.hammerman.com