custom subtotals

[Anonymous]

Hi All,

I have got a problem statement where i need subtotal of first two rows as third row value.

I am using this table:

BRAND	PRODUCT	PRICE
A	P1	20
A	P2	40
A	P3	10
B	P3	30
B	P1	90

and i need my pivot table as:

BRAND	PRODUCT	PRICE
A	P1	20
A	P2	40
	SUBTOTAL	60
A	P3	10
B	P3	30
B	P1	90
	SUBTOTAL	120

Thanks,

Stabdha

[Gysbert_Wassenaar]

See attached qvw.