pivot table not summarizing

[#1]

I have a plain and simple pivot table but my totals are not shown, why?

If i do the sum for the order number column, all works fine, but not for the amount; It just show zero

my code is

=sum(amount)

=sum(ordernumber)

ordernumber is a plain number like 201412345 while amount is a decimal with possible negatives.

Yes, i have checked the "show partial sum".

[Gysbert_Wassenaar · Accepted solution]

Perhaps the sum really is 0?

If not, try to post an example: Preparing examples for Upload - Reduction and Data Scrambling

[#3]

that was too easy; ok my fault thx