| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables with different groupings based on same data table
In Excel 2007 I have one data table, say Dates by Weight, and want to see and
save two pivot tables & charts, one grouped by weeks, the other by months. If I simply change the date grouping in one table, the other table also changes. I could create two separate data tables, but I'd like to be able to add new data to only one table. How can I keep the groupings in the 2 pivot tables distinct without losing the ability to update each of them when the main data table is updated? Thanks for any tips. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Distributing Pivot Tables where pivot table data can't be accessed | Excel Discussion (Misc queries) | |||
| Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
| Pivot Table-two tables same data, can I used the same page control | Excel Worksheet Functions | |||
| Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
| pivot table groupings | Excel Discussion (Misc queries) | |||
Threaded Mode
