I have a database with dates, sales and profits. I need to create report for
daily, monthly and yearly sales on different worksheets. I have created pivot
tables for reporting. But the problem is that when I group the date field on
monthly sheet by month, the same field is grouped by month on the quarter
sheet. I need the different groupings of date field on different sheets, but
this is not happening. It is not that the pivot tables are created from each
other. They are all created from the data source so why are they being
dependent on each other? I am using Excel 2003. Please help.