Report by Year, Qtr and by Day
 

How can i create a report by Year, Qtr, day using pivot?

Is it possible?

I have 200,000 data on my clipper program, and it has all the details by
date, can i use pivot to summarize report by year, qtr, day without
programming...

Thank you so much!

Report by Year, Qtr and by Day
 

Hi Rommel,

Drag the date field onto your pivot table as a row or column field, then
right-click it and select 'Group and Show Detail' from the drop-down menu.
Should be easy from there,

Go to http://www.edferrero.com/tutorials.aspx for more info.

Ed Ferrero
http://www.edferrero.com


How can i create a report by Year, Qtr, day using pivot?

Is it possible?

I have 200,000 data on my clipper program, and it has all the details by
date, can i use pivot to summarize report by year, qtr, day without
programming...

Thank you so much!