Spreadsheet: 89244d1288984682-pivottable-computed-field-question-pivotchartnumericranges
Sheet: Sheet1

Name | Category | Rank | Rating | Amount1 | Amount2 |  | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Column Labels
 | 20 | >=20 | <30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row Labels | 20 | 25 | 30 | Grand Total
 | Rank | Rating | Rating |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10-19
 | 20 | >=30 | <40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20-29
 | Rank | Rating | Rating |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30-39
 | 20 | >=40 | <50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40-49
 | Rank | Rating | Rating |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50-59
 | 20 | >=50 | <60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60-69
 | Rank | Rating | Rating |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70-79
 | 20 | >=60 | <70 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80-89
 | Rank | Rating | Rating |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total
 | 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