Pivot table

[Narayanan m s]

dear all
I have created an expense statement.
This has fields date, nature of expenses.
I want to construct a pivot table summarising total for each account by months as below:
Nature of. Apr. May. June
Expense

Rent. 400. 500. 500
Food. 80. 60. 100

How this can organised?
The file is for the year not for each month.

m s narayanan