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 crosstab/pivot table showing the month sales of each category and sub-category.
Include subtotals of the categories, as well as a grand totals, for each month.
Provide color to help illustrate sub-categories 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!