In previous stage, we have loaded the data sets, now its time for visualization:
- Create a list box for Country and Month. Country list box must be vertical with one column where as Month should be horizontal.
- Activate Show alternate option of Country list box.
- Create a bar chart with Country as a dimension and Sum of sales as an expression.
- Limit dimension to 10
- Display values on each bar
- Remove Limit and enable scrollbar on X- axis.
- Arrange country name by sum of sales.
- Play with formatting option under Colors, Number, Font, Layout and Caption
- Convert Column Chart to BAR Chart, Line, Pivot and Straight table