Generate a row that sums up the totals of the other rows by category

[iamkamara_jpm]

Hi all,

Looking to insert a new row that takes the total of the rows based on video game genre.

[Below is just sample data for illustrative purposes]

Below is what I have

Video Game Genre	Sales Amount
Adventure	10
Adventure	12
Adventure	14
Fantasy	21
Fantasy	5
Fantasy	14
Sports	40
Sports	12
Sports	14

Below is what I am want to output

Video Game Genre	Sales Amount
Adventure	10
Adventure	12
Adventure	14
Total Adventure	36
Fantasy	21
Fantasy	5
Fantasy	14
Total Fantasy	40
Sports	40
Sports	12
Sports	14
Total Sports	66
Grand Total ( Sports, Fantasy Adventure)	142

[JosephSerpis]

Hi @iamkamara_jpm one way you can achieve the output you describe is using the summarise tool and formula tool to sum up the genres and add Total or Grand Total. Then using unions tools with a sort tool you can bring this data together in order specified. I mocked up one approach to solve this. 

[Raj]

.

[Peachyco]

Another approach is to use the Tile Tool. If we tile by the unique values of the Genre, the Tile Sequence Number can be used to find the rows where the sub-totals need to be (whatever is the last sequence number for each genre, we increase it by 1).