I have a large pivot table.
The pivot table has 10 different report filters.
Each of the filters has several items - some with as many as several thousand.
I would like to be able to store the selections from a pivot table somewhere so that they can be used to reset the pivot table report filters to previously set combinations. The storing must be outside of memory so it is available when the file is reopened.
Example:
Filter 1: Possible options: A,B,C,D
Filter 2: Possible options: E,F,G,H
Filter 3: Possible options: I,J,K,L
User selects
F1: A,C
F2: E,F,G
F3: I,K
- store as scenario 1
User selects
F1: B,C
F2: E,F
F3: J,K,L
- store as scenario 2
and so on.
Thanks in advance
Marston
The pivot table has 10 different report filters.
Each of the filters has several items - some with as many as several thousand.
I would like to be able to store the selections from a pivot table somewhere so that they can be used to reset the pivot table report filters to previously set combinations. The storing must be outside of memory so it is available when the file is reopened.
Example:
Filter 1: Possible options: A,B,C,D
Filter 2: Possible options: E,F,G,H
Filter 3: Possible options: I,J,K,L
User selects
F1: A,C
F2: E,F,G
F3: I,K
- store as scenario 1
User selects
F1: B,C
F2: E,F
F3: J,K,L
- store as scenario 2
and so on.
Thanks in advance
Marston