Spreadsheet: 89326d1289118660-pivottable-computed-field-question-752198_bruiser
Sheet: Sheet1

Name | Category | Rank | Rating | Amount1 | Amount2 | Amt1_Alloc | This is a manually constructed table, to indicate how I want the automatically generated PivotTable to look.  Note the hidden columns, just to clean up the display a bit
Item9 | A | 25 | 19 | 5771 |  |  |  | #1 | #2 | 20 | #1 | #2 | 25 | #1 | #2 | 30
Item6 | B | 20 | 23 |  | 3886 |  | 10-19
Item3 | B | 30 | 23 |  | 4059 |  | 20-29
Item4 | B | 30 | 28 | 6000 |  |  | 30-39
Item10 | A | 20 | 29 | 5469 |  |  | 40-49
Item20 | G | 25 | 30 | 7085 |  |  | 50-59
Item13 | C | 30 | 33 | 9655 |  |  | 60-69
Item19 | G | 25 | 34 | 7169 |  |  | 70-79
Item4 | B | 20 | 36 | 3753 |  |  | 80-89
Item12 | C | 30 | 37 |  | 7315
Item14 | B | 20 | 38 | 5188
Item16 | E | 20 | 38 | 4692
Item12 | C | 20 | 39 | 6950
Item23 | G | 25 | 40 | 3780
Item17 | F | 20 | 42 | 6191
Item18 | G | 20 | 50 | 7350
Item22 | B | 20 | 50 | 4920
Item21 | G | 20 | 53 |  | 5875
Item11 | C | 25 | 60 | 5400
Item24 | G | 20 | 63 | 6846
Item7 | B | 20 | 69 | 10004
Item7 | B | 20 | 73 |  | 9272
Item5 | B | 20 | 80 | 8568
Item21 | G | 20 | 80 | 6696
Item7 | B | 20 | 87 |  | 8976
Item7 | B | 20 | 88 | 7595
 | Rank | Rating | Rating
 | 20 | >=10 | <20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This PivotTable should look like the manually constructed one starting at H3
 | Rank | Rating | Rating |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average of Amt1_Alloc | Column Labels
 | 20 | >=20 | <30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row Labels | 20 | 25 | 30
 | Rank | Rating | Rating |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10-19 |  | 1
 | 20 | >=30 | <40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20-29 | 0.5 |  | 0.5
 | Rank | Rating | Rating |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30-39 | 1 | 1 | 0.5
 | 20 | >=40 | <50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40-49 | 1 | 1
 | Rank | Rating | Rating |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50-59 | 0.6666666666666666
 | 20 | >=50 | <60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60-69 | 1 | 1
 | Rank | Rating | Rating |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70-79 | 0
 | 20 | >=60 | <70 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80-89 | 0.75
 | Rank | Rating | Rating
 | 20 | >=70 | <80
 | Rank | Rating | Rating
 | 20 | >=80 | <90
 | Rank | Rating | Rating
 | 20 | >=90 | <100
 | Rank | Rating | Rating
 | 25 | >=10 | <20
 | Rank | Rating | Rating
 | 25 | >=20 | <30
 | Rank | Rating | Rating
 | 25 | >=30 | <40
 | Rank | Rating | Rating
 | 25 | >=40 | <50
 | Rank | Rating | Rating
 | 25 | >=50 | <60
 | Rank | Rating | Rating
 | 25 | >=60 | <70
 | Rank | Rating | Rating
 | 25 | >=70 | <80
 | Rank | Rating | Rating
 | 25 | >=80 | <90
 | Rank | Rating | Rating
 | 25 | >=90 | <100
 | Rank | Rating | Rating
 | 30 | >=10 | <20
 | Rank | Rating | Rating
 | 30 | >=20 | <30
 | Rank | Rating | Rating
 | 30 | >=30 | <40
 | Rank | Rating | Rating
 | 30 | >=40 | <50
 | Rank | Rating | Rating
 | 30 | >=50 | <60
 | Rank | Rating | Rating
 | 30 | >=60 | <70
 | Rank | Rating | Rating
 | 30 | >=70 | <80
 | Rank | Rating | Rating
 | 30 | >=80 | <90
 | Rank | Rating | Rating
 | 30 | >=90 | <100