Home |
Search |
Today's Posts |
#1
|
|||
|
|||
PivotTable Contents
Hello-
I'm REALLY new at pivot tables and need to get up to speed quickly. They seem very powerful, but I'm just starting. Could you tell me how to get actual data in the data fields? I just get counts. I want the actual data (names not count). This must be a simple format thing, I just can't find it. Thanks. |
#2
|
|||
|
|||
PivotTable Contents
I still need help on this one.
If I go the "Field Settings", I can change count to sum or other math functions, but I want the actual text data NOT the count. (Like the salespersons name not the count of how many salespersons. I hope I'm clear on this, I really need help. Thanks. "DTTODGG" wrote: Hello- I'm REALLY new at pivot tables and need to get up to speed quickly. They seem very powerful, but I'm just starting. Could you tell me how to get actual data in the data fields? I just get counts. I want the actual data (names not count). This must be a simple format thing, I just can't find it. Thanks. |
#3
|
|||
|
|||
PivotTable Contents
The stuff in the data area is quantitative/numbers.
You can use labels in the row, column, page areas, though. DTTODGG wrote: I still need help on this one. If I go the "Field Settings", I can change count to sum or other math functions, but I want the actual text data NOT the count. (Like the salespersons name not the count of how many salespersons. I hope I'm clear on this, I really need help. Thanks. "DTTODGG" wrote: Hello- I'm REALLY new at pivot tables and need to get up to speed quickly. They seem very powerful, but I'm just starting. Could you tell me how to get actual data in the data fields? I just get counts. I want the actual data (names not count). This must be a simple format thing, I just can't find it. Thanks. -- Dave Peterson |
#4
|
|||
|
|||
PivotTable Contents
Don't drag it into a DATA area, drag it into a ROW field. If you suddenly
get a whol eload of unwanted subtotals then simply right click one of them and choose 'none' under the 'automatic subtotals' field. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "DTTODGG" wrote in message ... I still need help on this one. If I go the "Field Settings", I can change count to sum or other math functions, but I want the actual text data NOT the count. (Like the salespersons name not the count of how many salespersons. I hope I'm clear on this, I really need help. Thanks. "DTTODGG" wrote: Hello- I'm REALLY new at pivot tables and need to get up to speed quickly. They seem very powerful, but I'm just starting. Could you tell me how to get actual data in the data fields? I just get counts. I want the actual data (names not count). This must be a simple format thing, I just can't find it. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
Using contents of a cell in a formula | Excel Discussion (Misc queries) | |||
How to insert the contents of two cells in a footer? | Excel Discussion (Misc queries) | |||
Can I use the contents of a cell to satisfy the result_vector arg. | Excel Worksheet Functions |