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
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 | |||||||||
---|---|---|---|---|---|---|---|---|---|
AR | AS | AT | AU | AV | AW | AX | |||
36 | Data | ||||||||
37 | Category | Team | Sumof1 | Sumof2 | Sumof3 | Sumof4 | Sumof5 | ||
38 | Skin | 1 | 0 | 2 | 1 | 0 | 1 | ||
39 | 2 | 2 | 0 | 0 | 0 | 0 | |||
40 | 3 | 0 | 1 | 2 | 1 | 1 | |||
41 | 4 | 0 | 1 | 1 | 0 | 0 | |||
42 | 5 | 1 | 0 | 0 | 0 | 0 | |||
43 | DOB | 1 | 0 | 0 | 0 | 0 | |||
44 | Hair | 1 | 2 | 0 | 0 | 0 | 0 | ||
45 | 2 | 2 | 1 | 0 | 0 | 0 | |||
46 | 3 | 2 | 2 | 1 | 0 | 0 | |||
47 | 4 | 1 | 1 | 0 | 0 | 0 | |||
48 | 5 | 0 | 1 | 0 | 0 | 0 | |||
49 | 3rdTier | 0 | 1 | 0 | 0 | 0 | |||
50 | Oral | 1 | 1 | 0 | 0 | 0 | 0 | ||
51 | 2 | 0 | 1 | 0 | 0 | 0 | |||
52 | 3 | 1 | 0 | 0 | 0 | 0 | |||
53 | 4 | 1 | 0 | 0 | 0 | 0 | |||
54 | 5 | 0 | 1 | 0 | 0 | 0 | |||
55 | DOB | 1 | 0 | 0 | 0 | 0 | |||
56 | Spreads | 1 | 0 | 0 | 0 | 2 | 0 | ||
57 | 2 | 0 | 0 | 1 | 0 | 0 | |||
58 | 3 | 0 | 0 | 1 | 1 | 0 | |||
59 | 4 | 0 | 0 | 0 | 1 | 0 | |||
60 | 5 | 0 | 0 | 0 | 2 | 0 | |||
61 | 3rdTier | 0 | 0 | 1 | 0 | 0 | |||
62 | Dressings | 1 | 0 | 0 | 2 | 0 | 1 | ||
63 | 2 | 0 | 0 | 0 | 0 | 1 | |||
64 | 3 | 0 | 0 | 0 | 0 | 1 | |||
65 | 4 | 0 | 0 | 0 | 0 | 2 | |||
66 | 5 | 0 | 0 | 0 | 0 | 2 | |||
67 | DOB | 0 | 0 | 0 | 0 | 1 | |||
68 | IceCream | 1 | 0 | 0 | 1 | 0 | 1 | ||
69 | 2 | 0 | 0 | 0 | 0 | 1 | |||
70 | 3 | 0 | 0 | 0 | 0 | 1 | |||
71 | 4 | 0 | 0 | 0 | 0 | 1 | |||
72 | 5 | 0 | 0 | 0 | 0 | 1 | |||
73 | DOB | 0 | 0 | 0 | 0 | 1 | |||
74 | GrandTotal | 15 | 12 | 11 | 7 | 16 | |||
Data |