pivot table sum problems

[#1]

hi,

I have quiet a big problem. I have a pivot table and I am trying to sum my profit and it is always double the profit. I dont understand cause I also have a tablebox and it always shows me one entry on a specific date. but in the pivot table my profit is still double to the profit in my pivottable.

here is a screenshot. hopefully it helps for the understanding

[Anonymous]

Hi,

I'm pretty sure you've managed to load the data twice. Perhaps due to automatic concatenation.

Table Boxes only show distinct combinations of the values of the fields in the object.

Check that you're only loading the data set once.

[#3]

can i enable the distinct setting somehow?

[#4]

Hi,

I think the key's  are getting created twice for the same record or as Johannes has  mentioned the data set has been loaded twice. Try by putting distinct in the script where the common key field is defined between tables.