You went through three of the four calculation types in the previous chapter. In this exercise, you will see how the aggregation calculation type works. You can use this type in your chart and tables. You will learn about tables in Chapter 7, Working with Tables and Grids, so here you will create a new chart to experiment with this calculation type. The chart will display the average gross margin per store for each product type in each state.
- Create a new chart using the Chart option on the Insert toolbar.
- Set Data Source to Best Run Demo.
- From the Comparison category, select the Bar/Column option.
- Click the Add Measure link, and then select Click to Create a New Calculation. The instructions to ...