Show Only Total Row In Pivot

[Anonymous]

I have a requirement to suppress certain values in one of the dimensions of a pivot table to show only their Total values. For example, in below case, if Dim1 is 'B' then collapse (via Expression preferably) Dim2 and Dim3 to show only one row with subtotals for that section i.e. Dim1=B, Dim2=L1 and L2, Dim3=SL1 and SL2 and SL3.

Thanks.

Dim1	Dim2	Dim3	Exp1	Exp2	Exp3
A	L1	SL1
A	L1	SL2
A	L1	SL3
A	L2	SL1
A	L2	SL2
A	L2	SL3
B	L1	SL1
B	L1	SL2
B	L1	SL3
B	L2	SL1
B	L2	SL2
B	L2	SL3
C	L1	SL1
C	L1	SL2
C	L1	SL3
C	L2	SL1
C	L2	SL2
C	L2	SL3