Spreadsheet: 733282d1621486136-pivot-table-calculated-field-issue-sample
Sheet: With Field Item

Revenue | Column Labels
 | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4 |  |  | Grand Total
Row Labels | Offshore | Onsite | OffOn | Offshore | Onsite | OffOn | Offshore | Onsite | OffOn | Offshore | Onsite | OffOn
Heavy | 30 | 30 | 60 | 30 | 30 | 60 | 30 | 30 | 60 | 30 | 30 | 60 | 480
A-H | 10 | 10 | 20 | 10 | 10 | 20 | 10 | 10 | 20 | 10 | 10 | 20 | 160
A-L |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
A-P |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
A-R |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
B-H | 10 | 10 | 20 | 10 | 10 | 20 | 10 | 10 | 20 | 10 | 10 | 20 | 160
B-L |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
B-P |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
B-R |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
C-H | 10 | 10 | 20 | 10 | 10 | 20 | 10 | 10 | 20 | 10 | 10 | 20 | 160
C-L |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
C-P |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
C-R |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
LifeScience | 30 | 30 | 60 | 30 | 30 | 60 | 30 | 30 | 60 | 30 | 30 | 60 | 480
A-H |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
A-L | 10 | 10 | 20 | 10 | 10 | 20 | 10 | 10 | 20 | 10 | 10 | 20 | 160
A-P |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
A-R |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
B-H |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
B-L | 10 | 10 | 20 | 10 | 10 | 20 | 10 | 10 | 20 | 10 | 10 | 20 | 160
B-P |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
B-R |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
C-H |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
C-L | 10 | 10 | 20 | 10 | 10 | 20 | 10 | 10 | 20 | 10 | 10 | 20 | 160
C-P |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
C-R |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
[NAME] | 30 | 30 | 60 | 30 | 30 | 60 | 30 | 30 | 60 | 30 | 30 | 60 | 480
A-H |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
A-L |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
A-P | 10 | 10 | 20 | 10 | 10 | 20 | 10 | 10 | 20 | 10 | 10 | 20 | 160
A-R |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
B-H |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
B-L |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
B-P | 10 | 10 | 20 | 10 | 10 | 20 | 10 | 10 | 20 | 10 | 10 | 20 | 160
B-R |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
C-H |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
C-L |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
C-P | 10 | 10 | 20 | 10 | 10 | 20 | 10 | 10 | 20 | 10 | 10 | 20 | 160
C-R |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
Retail | 30 | 30 | 60 | 30 | 30 | 60 | 30 | 30 | 60 | 30 | 30 | 60 | 480
A-H |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
A-L |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
A-P |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
A-R | 10 | 10 | 20 | 10 | 10 | 20 | 10 | 10 | 20 | 10 | 10 | 20 | 160
B-H |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
B-L |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
B-P |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
B-R | 10 | 10 | 20 | 10 | 10 | 20 | 10 | 10 | 20 | 10 | 10 | 20 | 160
C-H |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
C-L |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
C-P |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
C-R | 10 | 10 | 20 | 10 | 10 | 20 | 10 | 10 | 20 | 10 | 10 | 20 | 160
Grand Total | 120 | 120 | 240 | 120 | 120 | 240 | 120 | 120 | 240 | 120 | 120 | 240 | 1920