2 Replies Latest reply: Mar 19, 2013 6:51 AM by Matthew Pertici RSS

    Pivot Table Custom Totals

      I am trying to write a pivot table with custom totals, but I can't figure out if it's possible to do.

       

      I have a dimension which is split into three categories, lets call them A, B, and C. I do not want to add A,B and C up, because the total doesn't make any sense. What I actually want to do is have a total for A, a total for B and a total for C. But Qlikview just wants to add all three up, I have attached a excel file which will hopefully explain it a bit better.

       

      Thanks