Pivot table Sub Totals help me please-

Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

In my pivot table i have three columns,

Country	state	city
A	A1	A11
A	A1	A12
		Total
A	A2	A21
A	A2	A22
A	A2	A23
		Total
B	B1	B11
B	B1	B12
		Total
B	B2	B21
		Total
B	B3	B31
B	B3	B32
		Total
	Total
Total

In the above example, i am hiding the first two columns as per my requirement by using a simple VB Script, after hiding I wanted to show the sub totals with the names not as 'total' like ... after A12 instead of Tatal i need to show A1, then after A23 i want to show A2 and so on. Please help me to achieve this. I am new to qlikview.

Thank you all for your help in advance.

topic Pivot table Sub Totals help me please- in QlikView

Pivot table Sub Totals help me please-