Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
could you transfer that pivot table to straight table and send us screenshot of displayed values?
regards
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!!
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.