Grouping Data in Pivot Tables
 

Hi there,

I have recently started with Pivot tables. Below mentioned table is
the one on which I have to create a pivot table such that the average
order by a given customer/company for each furniture type in a year.
I
can create the basic report with each furniture item showing its
average. I am interesting in grouping the furniture items namely as
indoor and outdoor furniture type. Indoor furniture type will contain
Wadrobe, Bed, drawers, coffee table and kitchen whereas outdoor
furniture type as chair and table. Is it possible to get the average
groupwise? Please, let me know it in detail as to how to go about it.


OrderDate CompanyName Town Wardrobe Bed
Drawers CoffeeTable
Kitchen Chair Table
4-Nov-00 Mullens Ballycullen 0
0 8 0 5 0 0
2-Sep-00 Mullens Ballycullen 0
2 4 2 0 0 0
2-Jul-00 Mullens Ballycullen 4
2 4 6 0 12 3
3-Jun-00 Mullens Ballycullen 0
0 0 0 5 16 4
5-May-00 Mullens Ballycullen 0
0 4 4 0 8 0
1-Mar-00 Mullens Ballycullen 2
0 0 4 0 0 0
3-Jan-00 Mullens Ballycullen 0
4 8 0 0 0 0
2-Sep-00 Garden Glories Glencullen 0 0
0 0 0 16 4
10-Aug-00 Garden Glories Glencullen 0 0
0 0 0 12 3
12-Jul-00 Garden Glories Glencullen 0 0
0 0 0 24 6
6-Jun-00 Garden Glories Glencullen 0 0
0 0 0 8 2
2-May-00 Garden Glories Glencullen 0 0
0 0 0 24 4


Thanks


Rashi Gadia

Grouping Data in Pivot Tables
 

see response to your posting in excel.misc

--
Regards

Roger Govier


wrote in message
ups.com...
Hi there,

I have recently started with Pivot tables. Below mentioned table is
the one on which I have to create a pivot table such that the average
order by a given customer/company for each furniture type in a year.
I
can create the basic report with each furniture item showing its
average. I am interesting in grouping the furniture items namely as
indoor and outdoor furniture type. Indoor furniture type will contain
Wadrobe, Bed, drawers, coffee table and kitchen whereas outdoor
furniture type as chair and table. Is it possible to get the average
groupwise? Please, let me know it in detail as to how to go about it.


OrderDate CompanyName Town Wardrobe Bed
Drawers CoffeeTable
Kitchen Chair Table
4-Nov-00 Mullens Ballycullen 0
0 8 0 5 0 0
2-Sep-00 Mullens Ballycullen 0
2 4 2 0 0 0
2-Jul-00 Mullens Ballycullen 4
2 4 6 0 12 3
3-Jun-00 Mullens Ballycullen 0
0 0 0 5 16 4
5-May-00 Mullens Ballycullen 0
0 4 4 0 8 0
1-Mar-00 Mullens Ballycullen 2
0 0 4 0 0 0
3-Jan-00 Mullens Ballycullen 0
4 8 0 0 0 0
2-Sep-00 Garden Glories Glencullen 0 0
0 0 0 16 4
10-Aug-00 Garden Glories Glencullen 0 0
0 0 0 12 3
12-Jul-00 Garden Glories Glencullen 0 0
0 0 0 24 6
6-Jun-00 Garden Glories Glencullen 0 0
0 0 0 8 2
2-May-00 Garden Glories Glencullen 0 0
0 0 0 24 4


Thanks


Rashi Gadia