Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi. I have 2 pivot tables using the same source data (a datasheet within the
workbook). For one of the pivot tables, I want to show the data by month. For the second pivot table, i want to show the data by quarters. So, for the second pivot table, i group the month fields. However, this grouping somehow affects the first pivot table and this table now shows quarters instead of the individual months that i want. How can group the fields of one pivot table without affecting the other pivot table? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
Pivot Table - Use Other Pivot Table as Data Source | Excel Discussion (Misc queries) | |||
How do I sort pivot table data outside a pivot table | Excel Worksheet Functions |