Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table & weeknum query
Within a pivot table, I have summarised the data firstly by month, then by
week, then by work type. I need to show the 'week commencing' date once for each week displayed. I had a limited amount of success by adding a column to the data area and used a formula (from Rick Rothstein - thanks) to display exactly this. When used in the pivot table however, it was treated as an individual entry rather than a 'group' heading. I understand why this has happened, but I need a work around. Even if there's a formula outside the pt which looks at column B (where weeknumber is) and works out the 1st date of the week from there. Thanks in advance. -- Traa Dy Liooar Jock |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table query | Excel Discussion (Misc queries) | |||
Pivot Table Query | Excel Discussion (Misc queries) | |||
Pivot Table Query | Excel Discussion (Misc queries) | |||
Pivot Table Query | Excel Discussion (Misc queries) | |||
Pivot Table, MS Query and Oracle | Excel Discussion (Misc queries) |