Subtotal for a group of rows

[gopinathpc]

Lets say I have rows like 101B,103B, 104B, 111B,113B and 114B.
If I want to group them like
101B,103B and 104B - category 1
111B,113B and 114B - category 2

I also want subtotals for each category - like subtotal for category1 and subtotal for category 2.

I am using the pivot table visulization.

How can I do this in QuickSight?

Thanks in advance!

[David_Wong]

Hi @gopinathpc,

You have to create a calculated field to do the grouping first. You can then enable the subtotal in your pivot table.