Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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
Best regards
Nils
Hi,
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?
Rebeca
Hi,
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
Best regards
Nils
Hi,
Include subtotals. Look at the example.
Hi,
The SubTotals helped somwhat, but I would like to have this outcome :
I created the data for "Created Acc..."
br
Nils