Benicio wants to examine the January, 2022 sales by country and channel. Create a PivotTable based on the Sales table as follows:
a. On a new worksheet, insert a PivotTable based on the data in the Sales table, and use January Pivot as the name of the worksheet.
b. Display the Channel Type values as column headings.
c. Display the Location values as row headings.
d. Sum the Amount values
Reading books is a great way to learn. Here are some of the books we recommend.
a. Go to Insert tab and then click Pivot Table dropdown. Then click "From Table/Range".
Make sure Table/Range is Sales and choose New Worksheet. Then hit Ok.
Right click on the Sheet1 (worksheet tab on bottom), click rename and type January Pivot.
b. Double click at pivot table, PivotTable Fields will appear. Click in Channel Type checkbox and drag it to the Columns.
c. Also select Location checkbox and drag-drop in Rows section.
d. For Amount checkbox drop in Values section.
Video Instruction