I am trying to create a report that shows the top 5 expenses for each month.

The underlying data is stored in a table with date, expense description and value. I have done the same report in Excel with the top 5 and attached a screenshot. This is what I expect the report to show for May.

I created a pivot table report in Zoho with date formatted as Month-Year, the expense description and the expense total aggregated as a sum.

I have also created a filter on the date to show only current financial expenses i.e April 2012 to July 2012, and a Top 5 on the Expense Total (Actual Value). The result is not as expected - see attached screenshot.

I am expecting to see top 5 expenses by the dimensions i.e. Time (ignoring the expense description field).

How do fix the report to show top 5 expense in each month?

Thanks

Sunil