Continue from Problem 8. Select HOME > PivotTable to create a PivotTable report from your integrated Power Pivot tables.
a. Use the ChannelName from the DimChannel table as the first rows field. Use the calculated column 1 field from the FactSales table as the second rows field. Use the SalesAmount field from the FactSales table as the values field. Change the number format to currency, if necessary; change the name of the calculated column 1 in the PivotTable report to Month; and change the values column name from Sum of SaleAmount to Total Monthly Sales. Change the report layout to tabular form.
b. Insert slicers for both ChannelName and Month.
c. Which channel had the highest total sales in January?
d. Add a column pivot chart. Change the title to Total Monthly Sales. Use the slicers to show the comparison among channels for sales in January.