Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

deerhunter
Contributor

Pivot calculations

We have 3 customers showing in the table. we want to show each customers sales in a column, then a total column for those customers.

We another column to show the 3 remaining customer totals and the last column needs to be a total of all customers.

Any help would be great...

Thanks

11 Replies
MVP
MVP

Re: Pivot calculations

What would be the required output, can you provide that in an Excel file?

deerhunter
Contributor

Re: Pivot calculations

Calculated Sample output.JPG

MVP
MVP

Re: Pivot calculations

I guess I don't understand what is Customer A, Customer B, Customer C.

You measures are just some variation of Sum(SalesAmount). Is this just a sample?

MVP
MVP

Re: Pivot calculations

This?

Capture.PNG

deerhunter
Contributor

Re: Pivot calculations

Yes just a sample

MVP
MVP

Re: Pivot calculations

Does the attached sample meets your requirement?

deerhunter
Contributor

Re: Pivot calculations

Sorry i don't see your Corrected App. Did you attach it?

deerhunter
Contributor

Re: Pivot calculations

Thank you that is perfect

oknotsen
Honored Contributor III

Re: Pivot calculations

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .

May you live in interesting times!