Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
There is something i don't understand.
I have a first table with some numbers "livreenfactur" "commandes ouvertes" etc..
And i want a pivot table with a field called "total dev soc" which is the sum of all the expression of the previous table.
So, total dev soc is on expression : "sum(livreenfacture"+ sum (commandes ouvertes) etc...
But the result is exactly the DOUBLE of the sum on the previous table. 23 964.24 € instead 11 982.12 € (which is the real result, like the first table).
Do you know why on my pivot table this is the double?
Thanks a lot and sorry for my bad english
If the first table is a table box, it will show only distinct rows.
Are you sure that in your datamodel that row is unique and not doubled?
Hi,
Try
SUM(AGGR(Sum(YourExpression),Your dimension Name from 1st table))
Regards
As is often the case, your screenshot shows the problem, but supplies no detail that might aid in resolving the problem. I suggest that you post your qvw or a representative sample to ensure relevant and accurate suggestions rather than a bunch of guesses.
can you send the qvwor a sample qvw that shows the issue?