0 votes
1 view
in BI by (13.4k points)

I have a data set with 13 rows, each representing a product type. Those 13 products then divided into 3 groups (an image of the data is attached below),

  • the first 7 products are in Group1
  • the next 3 products are in Group2
  • the last 3 products are in Group3

My task at hand is to insert a row that gives the subtotal of the first 7 products (i.e., Group1 in the table), then another row that gives the subtotal of the first 10 products (i.e., Group 1 & Group 2), and the grand total (i.e., all 3 groups). The first subtotal row should be inserted after Group1, and the second subtotal row should be inserted after Group2.

Any advise of how to achieve this would be greatly appreciated!

An Image of the Actual Data

Please log in or register to answer this question.

...