Let's say one of your primary responsibilities at the Superstore is to monitor the sales of Tables and Bookcases. You don't necessarily care about the details of other categories, but you do want to keep a track of how tables and bookcases compare with other categories. You might design something similar to the following screenshot:
Now you will be able to immediately see where Tables and Bookcases are compared to other categories as sales figures change day by day. Let's create this view by following these steps:
- Navigate to the Tables and Bookcases sheet.
- Place Category on Rows and Sales on Columns. Sort ...