
Partial Sum Totals Error in Pivot Table
swuehl Feb 7, 2012 4:36 PM (in response to yaman1510)Pivot tables will evaluate your partial sums as expression total, while you probably expect a sum of rows.
Please check the Help pages for 'Sum of rows in pivot tables' using advanced aggregation.
Your expression might need to be changed to something like
=sum( aggr( sum(Value), TableDimension1, TableDimension2, ...))
Hope this helps,
Stefan

Partial Sum Totals Error in Pivot Table
yaman1510 Feb 7, 2012 5:08 PM (in response to swuehl )Hi Stefan,
Thanks for your reply. I have 2 expressions as follows:
EXP 1) count( value)
EXP 2) count(value)/count( value2)
I'm using 2 dimensions. Now, I'm using the partial sums on 1 dimension , just to get the total of my expression 1. So, basically in my pivot table I want to add a Total row showing the expression total.
I'm not sure where to use the sum expression you stated above.
thanks. I will really apprecite your reply.

Partial Sum Totals Error in Pivot Table
swuehl Feb 7, 2012 5:16 PM (in response to yaman1510)When you are saying, you want the expression total, I think you should already see it...
Could you post a screenshot of your table here and the values for the total you expect to see?
If you want the sum of rows (what I still assume), you need to use your expression, i.e. the count( value) within the aggr() function, and then a sum around all to get the sum of rows, like
=sum( aggr( count( value), dimension1, dimension2))
You need to replace dimension1, dimension2 by your actual dimension field names, of course.
Regards,
Stefan


Partial Sum Totals Error in Pivot Table
swuehl Feb 7, 2012 6:36 PM (in response to yaman1510)So your first count should be 2660 and your second total 2609, right?
Have you tried the advanced aggregation, like
=sum( aggr( count( value), COLOR, STATUS))

Partial Sum Totals Error in Pivot Table
yaman1510 Feb 7, 2012 6:45 PM (in response to swuehl )Yes, you are right. The totals should be 2660 and 2609. If you are saying that i should another expressions =sum( aggr( count( value), COLOR, STATUS)), then that would add another column to it. And I've tried it, but its still not working. Its displaying nothing.
thank you.

Partial Sum Totals Error in Pivot Table
swuehl Feb 7, 2012 6:49 PM (in response to yaman1510)Well you could and should use the expression instead of your original one (but for testing, having another one should bother).
Please check that the field names are correct and correctly spelled, also the case is correct (field names are case sensitive). Are your field called 'value', 'COLOR' and 'STATUS' ?
Could you upload a small sample here?

Partial Sum Totals Error in Pivot Table
Vijay Kumar Feb 8, 2012 3:04 AM (in response to swuehl )Hi , I think this is problem of Loosly coupled dimensions. Are you using dimensions and expressions from two different tables lnked on some key. If yes the please chek your key this key is not giving you 1:1 linking.
Regards
Vijay


Re: Partial Sum Totals Error in Pivot Table
Iyyappan v Feb 8, 2012 3:15 AM (in response to yaman1510)Hi,
I attached sample Test.qvw file. It may help for you.
Regards,
Iyyappan.

test.qvw 118.5 K




Partial Sum Totals Error in Pivot Table
Krunoslav Pap Feb 8, 2012 8:33 AM (in response to yaman1510)Hi,
could you transfer that pivot table to straight table and send us screenshot of displayed values?
regards

Partial Sum Totals Error in Pivot Table
yaman1510 Feb 9, 2012 6:58 PM (in response to Krunoslav Pap)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!!






Re: Partial Sum Totals Error in Pivot Table
Rodrigo Lauro Jun 19, 2013 3:48 PM (in response to yaman1510)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.