| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
restrict data in a pivottable
Hi,
how can I resrtict the column and row values in a pivot table. for example of "date" is my column heading, and the base data has dates from 2004 and 2005, can I force the date "drop down" to only include those dates from 2005 (so you could never have the option of clicking a 2004 date) thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Copying conditional formatting...HELP PLEASE!!!! | Excel Worksheet Functions | |||
| Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
| PivotTable data... | Excel Discussion (Misc queries) | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Threaded Mode
