Hi - I'm having trouble trying to find the correct pivot table % of total formula... I've tried % of row and % of column, and % of "store" but am not getting the results I'm trying to get.
I'm pasting a sample below... basically the formula I'm trying to fix is in yellow... for the first one, I want to know what percent the $1 Albertsons apples are of the Albertsons store total?
I'm pasting a sample below... basically the formula I'm trying to fix is in yellow... for the first one, I want to know what percent the $1 Albertsons apples are of the Albertsons store total?
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
3 | store | item | Data | Total | ||
4 | albertsons | apples | Sumofamount | $1.00 | ||
5 | %ofstore? | 100.00% | ||||
6 | melon | Sumofamount | $4.00 | |||
7 | %ofstore? | 100.00% | ||||
8 | oranges | Sumofamount | $6.00 | |||
9 | %ofstore? | 100.00% | ||||
10 | pears | Sumofamount | $3.00 | |||
11 | %ofstore? | 100.00% | ||||
12 | albertsonsSumofamount | $14.00 | ||||
13 | albertsons%ofstore? | 100.00% | ||||
14 | ralphs | apples | Sumofamount | $2.00 | ||
15 | %ofstore? | 200.00% | ||||
16 | melon | Sumofamount | $7.00 | |||
17 | %ofstore? | 175.00% | ||||
18 | oranges | Sumofamount | $5.00 | |||
19 | %ofstore? | 83.33% | ||||
20 | pears | Sumofamount | $4.00 | |||
21 | %ofstore? | 133.33% | ||||
22 | ralphsSumofamount | $18.00 | ||||
23 | ralphs%ofstore? | 128.57% | ||||
24 | vons | apples | Sumofamount | $8.00 | ||
25 | %ofstore? | 800.00% | ||||
26 | melon | Sumofamount | $4.00 | |||
27 | %ofstore? | 100.00% | ||||
28 | oranges | Sumofamount | $2.00 | |||
29 | %ofstore? | 33.33% | ||||
30 | pears | Sumofamount | $5.00 | |||
31 | %ofstore? | 166.67% | ||||
32 | vonsSumofamount | $19.00 | ||||
33 | vons%ofstore? | 135.71% | ||||
34 | TotalSumofamount | $51.00 | ||||
35 | Total%ofstore? | |||||
Sheet4 |