Format the PivotTable as follows to make it easier for Benicio
and others to interpret:
Apply the Currency number format with
0 decimal places and the $ symbol
to the Sum of Amount values.
Use Sales (000s) as the custom name of the Sum
of Amount field.
In cell A4, use Country to identify the row
headings.
In cell B3, use Channel to identify the column
headings.
Change the PivotTable style to White, Pivot Style
Medium 14 to coordinate with the tables on the Current
Sales worksheet.
Meerico
Slp (Dlua; Tcncn Lska7- 374 Laneb DIs #tlje Cthef %bina RNn snaca "Jecol Canada 5406 540_5280 4808 Nexc0 5278 6o 3527 51042 51.822 5406 63 270 3nd Tclel 61,584 62,238 6788 8,817
PivotTable Fields
Choose Ile Os
report
Search
StID
Channel Type
Product
Location
Amount
Promotion
View Tables
Row field area below:
Filters
Columns
Channel Tree
Values
Data
Sales Col
Retail Audit
Current Sales
January Pivot Sales Projections
Suppliers
Product