How to do it…

  1. From the App overview, create a new sheet and enter the Edit sheet mode.
  2. Add the Dimensions field on to the main content pane.
  3. Drag a Bar chart object on to the content pane.
  4. Add the following expression as a measure:
Sum(Sales) 
  1. Add the following calculated dimension by clicking on the expression button:
=Pick(Match($(vDimension),'Weight','ProductType', 
'Category'),Weight,ProductType,Category)
  1. Enter one click of the space bar as the label to make it appear as if there is no dimension label.
  2. Exit the editor mode, and select a value in the Dimensions field.
  3. 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.
Reset