This content has been marked as final. Show 2 replies
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.