Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Partial Sum Totals Error in Pivot Table

Hi All,

I have created a pivot table and I'm using the partial sum total on one dimension from the presentation tab. The problem is the incorrect totals that are coming up. Any suggestions on how to correct the partial sum totals would really be appreciated.

Thank you in advance.

12 Replies
Not applicable
Author

Hi,

could you transfer that pivot table to straight table and send us screenshot of displayed values?

regards

Not applicable
Author

Thank you everyone for replying. I appreciate you replies. I used the advanced aggregation suggested above my Stefan and that solved all the program.

Thanks again!!

Not applicable
Author

Hi,
Can someone help me with this?

I have almost the same problem. I have an Expression  that is the multiplication of two parts (Part A * part B).
When I make the sum of my own for the two parts, and then multiply both TOTALS it is correct. But it is not the correct total for the pivot grid.

This is the Expression

(Sum(STOCK_AL_CIERRE_AJU)  - Sum(VENTA_AJU) + Sum(CAJAS))     // PART A

     *   

(sum(NIV)/sum( CAJAS)) // PART B

I only use one Dimension, it is YearMonth.