Alternative dimensions and measures can be made available in charts, and the user might select them to be used in the current visualization. These alternative dimensions and measures can be changed.
For this recipe, we will reuse the same data loading as for theCreating treemaps recipe.
- Drag a
Bar chart
object onto the content area. - Add
Product line
as a dimension. - Add
Product Group
using theAdd
alternative
button in the alternative dimensions section. - Add
Product Sub Group
using theAdd
alternative
button in the alternative dimensions section. - Add
Sum(Sales)
as a measure and label itSales
. - Add
Avg(Sales)
using theAdd
alternative
button in the alternative measures section and label itSales Average
. - Click on
Done
. - The finished result should resemble the following screenshot:
- Click on the
Product Line
label in the dimensions axis. A pop-up menu will show the current dimension selected with a tick and the alternate dimensions. - Select...