pivot table help

I've got a (non-pivot) table with 5 columns that looks like this:

HRG POD yr1data yr2data yr3data

HRG and POD are categories, and the figures in the 3 data columns are the
values of interest. I want to have HRG as the rows, and then I want 3 main
column headings: yr1data, yr2data and yr3data. however, there's only 5
possible values for POD, and I want each of the 3 data columns split into 5
subcolumns, each headed by a value of POD.

I can get the pivot table with HRG as rows and POD as columns, but I only
seem to be able to add the data by subdividing rows rather than columns, even
when choosing 'column area' in the 'add to' drop down.

any suggestions gratefully received

Debra
Thu May 08 06:51:53 CDT 2008

In the pivot table, drag the Data button into the column area
In the column area, move the POD button to the left of the Data button

Josie wrote:
> I've got a (non-pivot) table with 5 columns that looks like this:
>
> HRG POD yr1data yr2data yr3data
>
> HRG and POD are categories, and the figures in the 3 data columns are the
> values of interest. I want to have HRG as the rows, and then I want 3 main
> column headings: yr1data, yr2data and yr3data. however, there's only 5
> possible values for POD, and I want each of the 3 data columns split into 5
> subcolumns, each headed by a value of POD.
>
> I can get the pivot table with HRG as rows and POD as columns, but I only
> seem to be able to add the data by subdividing rows rather than columns, even
> when choosing 'column area' in the 'add to' drop down.
>
> any suggestions gratefully received


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

zeiderzeeAThotmailDOTcoDOTuk(DONOTSPAM)>
Thu May 08 07:01:00 CDT 2008

if I drag the data column into the column area, it generates columns based on
the values within the column, ie 1.6, 2.35 etc etc

"Debra Dalgleish" wrote:

> In the pivot table, drag the Data button into the column area
> In the column area, move the POD button to the left of the Data button
>
> Josie wrote:
> > I've got a (non-pivot) table with 5 columns that looks like this:
> >
> > HRG POD yr1data yr2data yr3data
> >
> > HRG and POD are categories, and the figures in the 3 data columns are the
> > values of interest. I want to have HRG as the rows, and then I want 3 main
> > column headings: yr1data, yr2data and yr3data. however, there's only 5
> > possible values for POD, and I want each of the 3 data columns split into 5
> > subcolumns, each headed by a value of POD.
> >
> > I can get the pivot table with HRG as rows and POD as columns, but I only
> > seem to be able to add the data by subdividing rows rather than columns, even
> > when choosing 'column area' in the 'add to' drop down.
> >
> > any suggestions gratefully received
>
>
> --
> Debra Dalgleish
> Contextures
> http://www.contextures.com/tiptech.html
>
>

Debra
Thu May 08 07:12:27 CDT 2008

There's a picture here, that shows what I mean:

http://www.contextures.com/xlPivot02.html

Does your pivot table have a Data button like the one in the picture?

Josie wrote:
> if I drag the data column into the column area, it generates columns based on
> the values within the column, ie 1.6, 2.35 etc etc
>
> "Debra Dalgleish" wrote:
>
>
>>In the pivot table, drag the Data button into the column area
>>In the column area, move the POD button to the left of the Data button
>>
>>Josie wrote:
>>
>>>I've got a (non-pivot) table with 5 columns that looks like this:
>>>
>>>HRG POD yr1data yr2data yr3data
>>>
>>>HRG and POD are categories, and the figures in the 3 data columns are the
>>>values of interest. I want to have HRG as the rows, and then I want 3 main
>>>column headings: yr1data, yr2data and yr3data. however, there's only 5
>>>possible values for POD, and I want each of the 3 data columns split into 5
>>>subcolumns, each headed by a value of POD.
>>>
>>>I can get the pivot table with HRG as rows and POD as columns, but I only
>>>seem to be able to add the data by subdividing rows rather than columns, even
>>>when choosing 'column area' in the 'add to' drop down.
>>>
>>>any suggestions gratefully received
>>
>>
>>--
>>Debra Dalgleish
>>Contextures
>>http://www.contextures.com/tiptech.html
>>
>>
>


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html