
Re: Why can the partial sums in pivot chart differ from the real sum of expression?
Sunny Talwar Feb 6, 2017 9:35 AM (in response to Александр Закревский)Try using Sum(Aggr())
Sum(Aggr(YourExpression, NOP, CID))

Re: Why can the partial sums in pivot chart differ from the real sum of expression?
Александр Закревский Feb 7, 2017 12:54 AM (in response to Sunny Talwar )Where should I use Sum(Aggr())? The sums in each row for every CID are correct. The wrong thing is the Total sum in the top row (you can check that by autosuming the whole column in the attached excel file) but as far as I know, I can't change the way of calculation for Partial Sums.

Re: Why can the partial sums in pivot chart differ from the real sum of expression?
Staffan Johansson Feb 7, 2017 1:42 AM (in response to Александр Закревский)Hi,
When use if in pivot, pivot tabel can handeling it rowwise, but can not aggregate in on total. Therefore is a Aggr function needed to sum up the total on each Dimension. You need to go through Your variables or maybe use the Expression itself instead of the variable to get it correct.
Because on total the Whole Expression is true, thats why.

Re: Why can the partial sums in pivot chart differ from the real sum of expression?
Александр Закревский Feb 7, 2017 2:21 AM (in response to Staffan Johansson)Thanks for clarifying the matter with the pivot and if!



Re: Why can the partial sums in pivot chart differ from the real sum of expression?
Александр Закревский Feb 7, 2017 2:20 AM (in response to Sunny Talwar )I've tried enclosing the whole expression in the Aggr's brackets and it worked. Thanks!
