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.
