Discussion Board for collaboration related to QlikView App Development.
I've got a problem showing accumlates sales in a Pivot-chart. I've looked at all the other questions in this forum regarding similar problems, but not found a solution.
The accumulation works fine if I have colapsed all.
If I expand any of the CustomerGroups, the "Accumulated Sales" goes wrong
Expression for "Accumulated Sales"
Rangesum(sum(Sales) / sum(Total Sales), Above([Accumulated Sales]))
Any ideas? I've attached a qvw showing the problem
There is no problem. When you expand the table, it shows the cumulative line by line. Did you, for instance, to produce 45% for the two lines Group Two?
Thanks for your reply.
But, there is a problem... the column "Accumulated Sales" should always give 100% at the last row. This is the case when all is colapsed - but as soon as one row is expanded the "Accumulated" goes wrong
Include subtotals. Look at the example.
The SubTotals helped somwhat, but I would like to have this outcome :
I created the data for "Created Acc..."