Make list as hierarchy from total, to region and then to product line
- Create normal list as below, sorted by region, product line and product type
- Group by region, product line and product type
- Summary for revenue
- Click list header & Footers, and then check overall header, region header and product line header. Please note that this structure matches list structure accordingly.
- Click all headers and split cell
- Drag all summary values from footers to headers, and move group items under product type column
- Click list header & Footers, and then uncheck overall footer, region footer and product line footer.
- Set first two column hidden, Box type =None; then change product type title as product, make padding region 10, product line 20, and product type 30
All three queries for relation, DMR are very similar.