Pivot table
 

Hi! I have a pivot table. In the actual table the data is shown as number of
occurences. Also the automatically created colmn and row "Total" shows the
total sum of the number of occureneces. However I wnat to show number of
occurences in the table and then the mean value at the end instead of total.
but when i try to change this the data in the table also changes. is there
any way to do this? thanks!

Pivot table
 

Hi Arne

You can drag the field to the data area a number of times.
If the field is numeric, then you could drag it onto he data area 3
times.
On the Layout tab,
double click the first occurrence and select Count.
double click the second occurrence and select Sum
double click the third occurrence and select Average

On the PT, drag the Data button across and drop it in Total, and you
will have the 3 values side by side



--
Regards

Roger Govier


"Arne Hegefors" wrote in
message ...
Hi! I have a pivot table. In the actual table the data is shown as
number of
occurences. Also the automatically created colmn and row "Total" shows
the
total sum of the number of occureneces. However I wnat to show number
of
occurences in the table and then the mean value at the end instead of
total.
but when i try to change this the data in the table also changes. is
there
any way to do this? thanks!

Pivot table
 

You can't change the summary function for just the grand totals. You
could add another copy of the value field, as Roger suggested, and set
it to show the Average.

Or, you could add a new column in your source data, e.g. Group
Then, enter the same value for all records, such as a 1 or a space
character.
Add that field as the first field in the Row area
Set it to Subtotal by Average
Remove the Grand Totals for columns.

Arne Hegefors wrote:
Hi! I have a pivot table. In the actual table the data is shown as number of
occurences. Also the automatically created colmn and row "Total" shows the
total sum of the number of occureneces. However I wnat to show number of
occurences in the table and then the mean value at the end instead of total.
but when i try to change this the data in the table also changes. is there
any way to do this? thanks!


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

Pivot table
 

That's a neat idea Debra!!!
Never ever thought of using space as a character for grouping.
And just as I was foolish enough to think I was becoming reasonably
proficient with PT's<bg

--
Regards

Roger Govier


"Debra Dalgleish" wrote in message
...
You can't change the summary function for just the grand totals. You
could add another copy of the value field, as Roger suggested, and set
it to show the Average.

Or, you could add a new column in your source data, e.g. Group
Then, enter the same value for all records, such as a 1 or a space
character.
Add that field as the first field in the Row area
Set it to Subtotal by Average
Remove the Grand Totals for columns.

Arne Hegefors wrote:
Hi! I have a pivot table. In the actual table the data is shown as
number of occurences. Also the automatically created colmn and row
"Total" shows the total sum of the number of occureneces. However I
wnat to show number of occurences in the table and then the mean
value at the end instead of total. but when i try to change this the
data in the table also changes. is there any way to do this? thanks!


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

Pivot table
 

Hi Arne,

I'm not sure what you mean by "actual table" - is that the pivot table or
the data table? Show a sample of what your pivot table looks like, like this?

Count of Occ.
A 4
B 5
C 6
Total 15

--
Thanks,
Shane Devenshire


"Arne Hegefors" wrote:

Hi! I have a pivot table. In the actual table the data is shown as number of
occurences. Also the automatically created colmn and row "Total" shows the
total sum of the number of occureneces. However I wnat to show number of
occurences in the table and then the mean value at the end instead of total.
but when i try to change this the data in the table also changes. is there
any way to do this? thanks!

Pivot table
 

I have Excel Table format as below:

Name Width HRS TPI Production

A 11 1 12 100
B 15 2 13 200
C 12 4 14 300
D 11 5 18 400
E 12 3 20 900

Now I want this table to look as:


12 13 14 18
20

11 A 100 1 D 400 5

12 C 300 4
E 900 3

15 B 200 2


IT means that lest side is "WIDTH" and Upper side "TPI"
While in data field the name,Production and HRS will be shown.
Using normal Pivot Table functions its not possible.
Please help me.
Waitting for reply.




"Roger Govier" wrote:

That's a neat idea Debra!!!
Never ever thought of using space as a character for grouping.
And just as I was foolish enough to think I was becoming reasonably
proficient with PT's<bg

--
Regards

Roger Govier


"Debra Dalgleish" wrote in message
...
You can't change the summary function for just the grand totals. You
could add another copy of the value field, as Roger suggested, and set
it to show the Average.

Or, you could add a new column in your source data, e.g. Group
Then, enter the same value for all records, such as a 1 or a space
character.
Add that field as the first field in the Row area
Set it to Subtotal by Average
Remove the Grand Totals for columns.

Arne Hegefors wrote:
Hi! I have a pivot table. In the actual table the data is shown as
number of occurences. Also the automatically created colmn and row
"Total" shows the total sum of the number of occureneces. However I
wnat to show number of occurences in the table and then the mean
value at the end instead of total. but when i try to change this the
data in the table also changes. is there any way to do this? thanks!


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