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