Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all
I have a big problem and i have not idea how to solve it.
I have a pivot table with a sum function, I have selected only one record and sum is double of the value.
If I put field as dimension i can show that it's different,
Here's an example
| PES | COUNT | SUM(PES) |
| 1950 | 1 | 3900 |
But if I put the expression without sum it returns correct value.
| PES | COUNT | PES |
| 1950 | 1 | 1950 |
Problem is to solve that because it must be a sum. I'm doing only with one record to found error
Thanks for your help
Probably you have a two records about that dimensions.......
....we need check you model....if you can......put here to check....