| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
grouping using a automated day field in a pivot table
I have a excel database that I am using for a pivot table which has an
automated day of the week field in it. I have a formula in Column B for the day of the week which is worked out by the date in Column A. Formulas I have tried in Column B have been =if(A10,weekday(A1,2),"") and if(A10,A1,"") [with B1 being just formatted as a "dddd" date format. Both of these are showing OK in the column but when used in the pivot table and I try and group and total on day of the week, then excel is still seeing it as a date (ie grouping on 15/2/2007,16/2/2007 etc). Does anyone know how to get a pivot table to group and total on day of the week, or do I have to enter the data in manually in the database? Any help much appreciated. Regards -- Gai |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
| Automated Page Breaks In Pivot Table | Excel Discussion (Misc queries) | |||
| Grouping a data field in a pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table Grouping or Calculated Field | Excel Discussion (Misc queries) | |||
| grouping field in pivot table! | Excel Worksheet Functions | |||
Threaded Mode
