Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
i have a really tricky Problem. Somehow the aggregation of my data in a pivot table is not working properly.
I've made a screenshot:
In the table the sum is ca 48 and in the pivot its doubled? (P.S: in the Combi Diagramm its also wrong)
Any idea?
cheers chesterluck
well, I don't think that it is the join (anyway I will test it). I think it is connected to the 3rd load (resident load).
See, im doing first a left join and then, in order to perform an if statement with data from both tables, I'm doing the resident load. I don't know whether it is the correct way...
P.S.: i found here sth., maybe it leads to the solution:
Issue solved. It was a join on a later stage. Thx for the support