Pivot table - stop it summing date entries

Hi all,

How do I stop a pivot table adding data together?

e.g.

1st Nov -100
1st Nov - 100
2nd Nov - 200
2nd Nov -200

I want this but instead get this:

1st Nov - 200
2nd Nov - 400

I need the pivot to split it out, any ideas?

Thanks all.
Matt

I do not think you want a pivot table at all but if you use one you must put the data into row fields and not value fields.