How to do it…

  1. Drag a Table object onto the content area and label it Product Sales.
  2. Add ProductType as a dimension.
  3. Add the following expression as the first measure and label it Total Sales:
Sum (Sales)
  1. Add the following expression as the second measure and label it Sub Category Sales:
Sum ({<Category = {$(=concat (distinct [SubCategory], 
','))} >} Sales)
  1. You should have a table that looks similar to 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