The following are the steps:
- Within the workbook associated with this chapter, navigate to the worksheet entitled Altered Pie Map and select the Superstore data source.
- Create the following calculated fields:
Name |
Code |
Log Sales |
LOG(SUM(Sales)) |
Category State Sales |
{FIXED State, Category: SUM(Sales)} |
State Max |
{FIXED State : MAX([Category State Sales])} |
Top Selling Category per State |
MAX(If [State Max] = [Category State Sales] then Category END) |
- Within the MarksView card, set the view type to Pie.
- Place Log Sales on the Size shelf.
- Within the Data pane, select the States data source.
- Click the chain link next to State in the Data pane in order to use ...