sorry, I must be doing something wrong.

I get plant id, then product...but for net I get every weight for
every product... I just need the total for each product.

I double clicked on both product and net to pick SUM, by it didn't
change it.

Also once I have the year to date total I still need to pull up
monthly totals, can i do that with a pivot table?

Thanks

Wally





On Sun, 31 Jul 2005 21:05:58 +0100, "Roger Govier"
wrote:

If you drag Net to the data area as well, double click on the filed name and
choose Sum, then you will have weight as well as count of tickets.