- From the App overview, create a new sheet and enter the Edit sheet mode.
- Add the Dimensions field on to the main content pane.
- Drag a Bar chart object on to the content pane.
- Add the following expression as a measure:
Sum(Sales)
- Add the following calculated dimension by clicking on the expression button:
=Pick(Match($(vDimension),'Weight','ProductType',
'Category'),Weight,ProductType,Category)
- Enter one click of the space bar as the label to make it appear as if there is no dimension label.
- Exit the editor mode, and select a value in the Dimensions field.
- The final product should resemble the following screenshot:
..................Content has been hidden....................
You can't read the all page of ebook, please click
here login for view all page.