What can possibly be wrong with my pivot table?

[Anonymous]

I am trying to create a pivot table showing booking values. For the orders with multiple products, the booking value is repeating in my pivot table and the total amount is also miscounted. (see attached.)

What can possibly be wrong with my table...?

Please help.

Thanks a lot,

Lyn

[Anonymous]

Lynn,

Need your application to give a good answer.  My guess is that either you aggregate Bookings per Order in the script, or in the chart expression.

Regards,

Michael