Pivot Table Partial Sums not displaying

[Anonymous]

Hi All,

I have the below issue, i know the field Total is in,my intention is to exclude this on load, however the problem remains.  My partial sums calculation does not work, I have changed the format of my QTY fields to NUM, but did not seem to resolve the issue.

Please assist, what am I missing here?

The partial sums is set up on Description, as i want the totals pertaining to all the descriptions together?

Thanks in Advance !

[sunny_talwar · Accepted solution]

Are you using the field names without any aggregation here? Like QTY is a field which is being used here without the Sum() function? If that is true, then try this Sum(QTY)

[Anonymous]

Hi Ruan,

It is normal because the pivot table evaluate your partial sum like this : total of QTY for all description by FILE.

Try to use "Sum of rows" ; may be it will be your solution.

Go to the expressions tab and check sum of rows.

[Anonymous]

This seems to work , however, the total displayed is incorrect.

[Anonymous]

Hi,

The option to sum by rows is grayed out.  however the above solution by Sunny is working, just needs tweaking.

Regards,

[sunny_talwar]

What is it displaying? What do you expect it to display?

[Anonymous]

Sorry, I was just looking at the wrong total, thought the total was at the bottom not top. Thanks for your help !

Much appreciated.

[sunny_talwar]

No problem.. you can move the placement of total on the presentation tab.... If you got what you wanted, please close this thread by marking correct and helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny