View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Alojz Alojz is offline
external usenet poster
 
Posts: 161
Default Grouping COLUMNS.

Hi, u need separate column for each month which will be not grouped with week
columns. Either leave this separate column blank or fill it with aggregate
value for given month (e.g. sum of values for all weeks in the month), but do
not group this column with other (weeks) columns.

"stevepru" wrote:

Hi, how do I group columns like you group rows ? I'm trying to create a
grouped column for each month and the individual weeks as columns that could
be grouped by month. I can group jan wk1-4 but when i try to do the same for
feb it just extends the group from jan to include feb. I want be able to '+
expand' & '- collapse' each month independently. Idea's ?

January February
wk1; wk2; wk3; wk4 wk1; wk2; wk3; wk4