calculate flow

[#1]

I got a database with updates every night.

ex.

I got the fields ITEM - AMOUNT - DATE.

What I want is to make a chart showing the flow per day.

so something like take a view everyday - what was the amount the 1. january - 2. jan..........

and when it has run a year I can see what was the amount of items at a specific date

any good thoughts or ideas are really appreciated

regards

[tresesco]

Pivot table:

Dimension1: Item

Dimension2: Date

Exp: Sum(Amount)

?