Old MathJax webview

sum of units count of units units count none of the above units total

To create the below pivot table, with Sales Reps in the columns and Regions in the rows, and the total number of units sold by each Sales Rep in each Region, the proper item in the Values (red shaded) field is: A B D E G H 1 K M N PivotTable Fields Choose fields to add to report Sum of Units Column Labels 4 Row Labels Chin Franks Gault Pham Sloux Smith Grand Total Bellen 1,209 1,585 1,596 1,383 1,536 1,317 8,626 6 Carlota 1,240 1,499 1,545 1,717 1,396 1,346 8,743 7 Quad 1,441 1,470 1,334 1,033 1,691 1,420 8,389 8 Sunset 1,327 1 354 1,091 1,327 1,401 1,724 8,224 9 Sunshine 1,420 958 1.809 1.579 1,353 1,868 8,987 10 Grand Total 6,637 6,866 7,375 7,039 7,377 7,675 42,969 11 12 13 14 15 16 17 18 19 20 EDate Product Region SalesRep Customer Units Sales COGS Yes MORE TABLES Drag ties between areas below Y FILTERS COLUMNS SalesRep 21 1 22 23 24 25 26 ROWS VALUES Produce 27 PH 29 30 31 12 33 14 OS 36 37 Layout data Sum of Units O Count of Units