| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot tables field grouping
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Grouping in Pivot Tables | Excel Worksheet Functions | |||
| Grouping in Pivot Tables | Excel Worksheet Functions | |||
| Pivot table: Grouping first row field by fifth row field | Excel Programming | |||
| grouping in pivot tables | Excel Discussion (Misc queries) | |||
| grouping field in pivot table! | Excel Worksheet Functions | |||
Threaded Mode
