Expression Total

[sibideepak]

I have table with following data :

CategoryType    Category    Total

a                        a1            3

a                        a2            2

a                        a3            5

b                        b1            3

b                        a2            3

c                        c1            1

c                        c2            5

c                        c3            4

but I want something like

CategoryType    Category    Total

a                      SubTotal   10

a                        a1            3

a                        a2            2

a                        a3            5

b                       SubTotal    6

b                        b1            3

b                        a2            3

c                       SubTotal   10

c                        c1            1

c                        c2            5

c                        c3            4

[tresesco]

Have you tried pivot table with sub total enabled?

[er_mohit · Accepted solution]

See the attached file

[sibideepak]

I am trying with it but could not !!

[sibideepak]

I could not able to find attachment