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