Grouping COLUMNS.

S

stevepru

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
 
A

Alojz

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spreadsheet Formulas 0
Count Weeks in a Month 7
Weeks in a Calendar 2
3 Weeks Forecast-Excel 2003 4
Return a Specific Value 9
averaging time values 1
counting absentees 1
Merging Queries 1

Top