Tableau Insert Customized Rows of Subtotals

Question

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!

Answer 1

Go to format add totals and add subtotals

If you want to become an expert  in Tableau and get a certificate, then checks out the Tableau course from Intellipaat

Also, do have a look at our YouTube video to help you get started with tableau training.