Need HELP to create a Simple Report

[rajtak]

Hi,

I've three columns excelsheet and want to create Per day report.

Date,Records,Status

I want to count per day records and status.

This will be self-explanatory when you check this screenshot. Please suggest me some functions/formulas.

 

[rajtak]

You can find a good walkthrough for 2007 here. You need to put the Date field in the Row area, the Status field in the Column area and the Records field in the data area (it should default to count)

@rorya, Thanks a lot for your suggestion. This is what i needed.