pivot table sums

dopydette

New Member
Joined
Jan 23, 2003
Messages
29
I have created the pivot table below, but instead of summing the actual data occurences, what I need is the total excluding the Team whose row is concerned, and DOB and 3rd tier.

For example, AT38 would read 3, AU38 = 2.

This does not need to be done in this pivot table, an external table would be fine, although I'm unsure how to do this calculation from a pivot table.

any help much appreciated
thank you
Fact Base v23.xls
ARASATAUAVAWAX
36Data
37CategoryTeamSumof1Sumof2Sumof3Sumof4Sumof5
38Skin102101
39220000
40301211
41401100
42510000
43DOB10000
44Hair120000
45221000
46322100
47411000
48501000
493rdTier01000
50Oral110000
51201000
52310000
53410000
54501000
55DOB10000
56Spreads100020
57200100
58300110
59400010
60500020
613rdTier00100
62Dressings100201
63200001
64300001
65400002
66500002
67DOB00001
68IceCream100101
69200001
70300001
71400001
72500001
73DOB00001
74GrandTotal151211716
Data
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Forum statistics

Threads
1,216,512
Messages
6,131,091
Members
449,618
Latest member
lewismillar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top