Hi,
I have some data like this:
Col A Col B Col C
AAA Equity 100
AAA Bond 200
AA Equity 50
AA Bond 300
And I would like to present like this:
AAA 300
Equity 100
Bond 200
AA 350
Equity 50
Bond 300
I’ve no idea how to use the grouping and subtotal on one line and the detail below
I have had a look at the documentation and the use of the grouping parameters but I can’t work it out, please help!