| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Three Pivots Linked By Page - Possible???
Hi, I have three pivots which had to be seperated. All of them have the same
Filters in the Page Area. I would like to be able to change one of the filters and have the other 2 pivots filters change in the same way... Is this Possible?????? Please say so. On a side note... I thought If functions could do 7 in one formula, it cuts me out at 6, I just need that one extra one to get my formula to work. Whoever can figure this out ROX! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Three Pivots Linked By Page - Possible???
Check out these links
Pivot Tables... http://www.contextures.com/excelfiles.html#Pivot Nested If's http://www.cpearson.com/excel/nested.htm -- HTH... Jim Thomlinson "Schwimms" wrote: Hi, I have three pivots which had to be seperated. All of them have the same Filters in the Page Area. I would like to be able to change one of the filters and have the other 2 pivots filters change in the same way... Is this Possible?????? Please say so. On a side note... I thought If functions could do 7 in one formula, it cuts me out at 6, I just need that one extra one to get my formula to work. Whoever can figure this out ROX! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Three Pivots Linked By Page - Possible???
You can do that with programming. There are sample files he
http://www.contextures.com/excelfiles.html Under PivotTables, look for: 'PT0016 - Change Page Fields With Cell Dropdown' 'PT0008 - Change Multiple Page Fields' 'PT0003 - Change Page Field' Schwimms wrote: Hi, I have three pivots which had to be seperated. All of them have the same Filters in the Page Area. I would like to be able to change one of the filters and have the other 2 pivots filters change in the same way... Is this Possible?????? Please say so. On a side note... I thought If functions could do 7 in one formula, it cuts me out at 6, I just need that one extra one to get my formula to work. Whoever can figure this out ROX! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formats and Pivots | Excel Discussion (Misc queries) | |||
| How do I create multiple worksheets from Page Pivots | Excel Worksheet Functions | |||
| master select page field for many pivots in one work book | Excel Discussion (Misc queries) | |||
| creating 1 linked page from 26 pages | Excel Discussion (Misc queries) | |||
| Multi-Page Word Doc Linked to Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
