I'm not sure if I've understood, but the general form for getting sum of rows in a pivot table is to change your expression like this:
sum(aggr(Your Expression, Your Dimensions))
So you may want an expression similar to this, just using your dimensions instead of the ones I threw in there:
Hi again John
I'm facing another problem related to this issue. Even if the column I asked you is alright, now I have to do another column with the % of the first, ie., I need to have the proporcion in %. However, as values are custom I don't know how to do this column.... Can you help me?
Thanks in advance!
How are you calculating the percent now? Or are you not doing it at all yet? It looks like QlikView calculates subtotal percents just fine using either column numbers or column labels, even when using weird sum(aggr(...)) expressions. So one of these for example:
column (3) / column (4)
Profit / Revenue
I'm not doing it at all because I don't know how to do it. However your answer was very useful for future problems!
Well, I think that won't solve my problem. I'll try to explain in more detail what I need to do.
I have a column that is costumized (that one you helped me with sum(aggr(...))) and I need to have another column with the percent of the previous column.
Column 1 Column 2
sub Total 50 50/50
sub Total 120 120/120
Total 170 170/170
Column 1 = Costumized with sum(aggr(...))
I hope I had been more clear
Thanks in advance.