Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 2002 Pivot Table Date
What format should the date be to use the year portion (database is only two
digits) as rows or columns? The current date format is 12-JAN-98. All transactions will total by year. Example: Transactions: 02 03 04 xxxxxxxxxxx xxxxxxxxxxx Transactions are summarized by G/L. |
#2
|
|||
|
|||
Dave,
Format doesn't matter, as long as they are truly dates: simply drag your date to the row field, then select it and use the grouping command button on the pivot table drop-down. Then select years, and it will group the data by year. HTH, Bernie MS Excel MVP "~Dave~" wrote in message ... What format should the date be to use the year portion (database is only two digits) as rows or columns? The current date format is 12-JAN-98. All transactions will total by year. Example: Transactions: 02 03 04 xxxxxxxxxxx xxxxxxxxxxx Transactions are summarized by G/L. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping in Excel on a Pivot table, need to be able to retrive ex. | Excel Discussion (Misc queries) | |||
How to group date in pivot table | Excel Discussion (Misc queries) | |||
Pivot Table in Excel 2002 | Excel Discussion (Misc queries) | |||
Converting a date in Excel 2002 to a Year/Quarter format | Excel Worksheet Functions | |||
How do I display a data table in an Excel 2002 chart? | Charts and Charting in Excel |