Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to set up multiple pivot tables on the same data -- one worksheet
to routinely genrate updted reports or charts as data is added. Some charts show trend data by year, which I get by grouping the date entries to "year." Another report reflects seasonality, which I get by grouping by month. However, whenever I change the grouping on one table or chart, it changes on all others. Any ideas? So far, it seem like all other items remain particular to the table cjosen, e.g. variables, value field settings, etc. but if there is anything else that would behave like grouping, I nee to know how to keep that fixed as well. Thanks, Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
build a pivot table from multiple other pivot tables. | Excel Discussion (Misc queries) | |||
Two pivot tables on the same worksheet? I need help... | Excel Worksheet Functions | |||
how do I consolidate multiple pivot tables into one pivot table? | Excel Discussion (Misc queries) | |||
Multiple Pivot Tables? | Charts and Charting in Excel | |||
Multiple Pivot tables from One selection | Excel Discussion (Misc queries) |