I'm facing an issue here and I need some help from the experts! Well, I have a pivot table with 3 dimensions (for the record, the 3rd is a drill-down group) and 5 expressions. In the 5th expression the ideia is to custom some values:
With this code I want to subtract some cells and to put other with value 0. Until here, everything seems to be working well. However, when I looked at sub-totals, I realize that totals don't change with the customization. Anyone knows why's that? I really need to customization some values on that expression... Nevertheless, If everyone knows another more specific to do that, please let me know.
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?
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: