Hide subtotals in pivot table

[sreenivasareddy]

Dear All, I have a requirement as follow
in qlikview pivot table I want to show sub titles only for
Column2 (A & B (shown in blue color))  and   hide sub titles for  Column2(B to N (shown in red color)). Cn you please help me.

Column1	Column2	Column3	Sales
aaa	A	A1	0.1
A2	4.0
A3	20.7
A4	4.8
A5	0.0
A6	0.0
Total	29.5
B	B1	0.0
B2	0.4
B3	0.0
B4	0.0
Total	0.4
C		0.1
D	Total	0.1
E		0.0
F	Total	0.0
G		0.0
H	Total	0.0
I		0.0
J	Total	0.0
K		3.4
L	Total	3.4
M		23.8
N	Total	23.8

[marcus_sommer · Accepted solution]

You could try it with an approach to NULL those rows by querying the dimensionality(), maybe with an expression like:

if(match(Column2, 'A', 'B'), sum(Sales), if(dimensionality() = 1, null(), sum(Sales))

- Marcus

[sreenivasareddy]

Thank you very much Marcus it's resolved my problem.