0 Replies Latest reply: May 30, 2012 10:17 AM by Ramakanth Konatham RSS

    Pivot table Sub Totals help me please-

    Ramakanth Konatham

      Hi All,

       

      In my pivot table i have three columns,

       

      Countrystatecity
      AA1A11
      AA1A12
      Total
      AA2A21
      AA2A22
      AA2A23
      Total
      BB1B11
      BB1B12
      Total
      BB2B21
      Total
      BB3B31
      BB3B32
      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.