Format the PivotTable as follows to make it easier for Benicio and others to interpret:
a. Apply the Currency number format with 0 decimal places and the $ symbol to the Sum of Amount values.
b. Use Sales (000s) as the custom name of the Sum of Amount field.
c. In cell A4, use Country to identify the row headings.
d. In cell B3, use Channel to identify the column headings.
e. Change the PivotTable style to White, Pivot Style Medium 14 to coordinate with the tables on the Current Sales worksheet.
Reading books is a great way to learn. Here are some of the books we recommend.
a. Click on Sum of Amount dropdown which is at Values group. Click at Value Field Setting, model will apear. Click on Number Format button which is at bottom of the left side. Select Currency number format and change the decimal places to 0 and symbol to $.
b. Click at Sum of Amount dropdown and then click at Value Field Setting, model will apear. TypeSales (000s) as the custom name.
c. & d. Double click on the given cells and type the given value.
e. Click on any cell of pivot table. Design tab will appear, click it. Expand the style palette of PivotTable Styles group, hover on different item under medium tab and select the one which says White, Pivot Style Medium 14 (last item of second row on Medium group in my version)
Video