Example - is least profitable always unprofitable?

Let's say you've been tasked with helping Management for the superstore chain find which items are the least profitable. Management feels that the least profitable items should be eliminated from the inventory. However, as you've done your analysis, you've discovered that certain items, while not profitable overall, have made profit at times in various locations. Your primary objective is to give management the ability to quickly see an analysis of the least profitable items to identify whether an item has always been unprofitable. This example will combine aspects of a guided analytics dashboard and an exploratory tool.

Building the views

Let's start by creating the individual views that will comprise your dashboard:

1. Create a bar chart showing profit by category. Sort the categories in descending order by the sum of profit.

2. Add the Department field to Filters and show a filter. To accomplish this, use the drop-down menu of the Department field...