Pivot tables?

Jamie M

New Member
Joined
Aug 15, 2002
Messages
18
I have just discovered the Pivot table function. Is it possible to make it just report actual information from the spreadsheet in this field instead of functions of it (e.g. Count, Sum etc)??? Pivot tables do exactly what I would like to do in terms of sorting data from several sources, however all I want it to do is repeat the original rows. I would really appreciate some help!!!
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
I have often wondered the same thing. If only the pivot table would allow a "None" option in the aggregate funcion list! This would have been ideal for plotting families of x-y plots (for different z's) from database-style tables, for instance.

My workaround is to select 'average', which is the only function that does not mess up your data too much. (Unless you have two or more data points with the same x and y, in which case the two points get collapsed into one point in your pivot table).

So selecting average may work for you if it's the general trend that you want to display.
This message was edited by Swamp Thing on 2002-08-19 01:26
 
Upvote 0
If the rows all have different names it should be ok.... shouldn't it? The only problem is that some of the fields are text!!
 
Upvote 0
"The right tool for the right job!" If all you want is a listing of your data then use SQL rather than a PivotTable.
 
Upvote 0

Forum statistics

Threads
1,224,427
Messages
6,178,585
Members
452,859
Latest member
dallasazcat

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top