Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Pivot Accumulate - 2 dimensions

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.

Clipboard01.jpg

If I expand any of the CustomerGroups, the "Accumulated Sales" goes wrong

Clipboard02.jpg

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

4 Replies
Not applicable
Author

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

Anonymous
Not applicable
Author

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

Not applicable
Author

Hi,

Include subtotals. Look at the example.

Anonymous
Not applicable
Author

Hi,

The SubTotals helped somwhat, but I would like to have this outcome :

Clipboard03.jpg

I created the data for "Created Acc..."

br

Nils