Question: Create a dashboard that presents the following: A crosstab / pivot table showing the month sales of each category and sub - category. Include subtotals
Create a dashboard that presents the following:
A crosstabpivot table showing the month sales of each category and subcategory.
Include subtotals of the categories, as well as a grand totals, for each month.
Provide color to help illustrate subcategories with the greatest sales.
Sales is a currency, so it should have a $ and in this case, it should NOT have any decimal places we are not interested in pennies.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
