If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
#2
|
|||
|
|||
Hi confused,
Right-click the date column heading. Select Group and Show Detail, then Group... from the pop-up menu. Group by Days and Years, then click OK. Drag the Years column heading to the Page Field area. Select a year from the page field drop-down. More detail is available at my Pivot Table tutorial at http://edferrero.m6.net/tutorials.html Ed Ferrero http://edferrero.m6.net 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 | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
transpose | john | Using Forms | 1 | November 24th, 2004 07:16 PM |
Import data to pivottable | MJP | General Discussion | 1 | November 18th, 2004 01:46 PM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Mial merge data base problems | Rachael | Mailmerge | 16 | May 21st, 2004 06:22 PM |
Pivot Tables compatibility - 97 and 2000 ? | Clarence Crow | Worksheet Functions | 5 | January 5th, 2004 06:48 PM |