Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with pivot table
My ignorance of pivot tables is causing me grief, I'd appreciate some help.
At least I think I should be using a pivot table. On a worksheet I have a number of rows with 3 columns (Date, Name and Activity). I'd like to present that data in a pivot table with Name as the Row Heading, Date for the Column heading and Activity as the data. The wizard will only let me put a "Count of Activity" or "Sum of Activity" in the data field. How do I get it to just put the Activity code there, not a count or sum or any other aggregate. Thanks in advance for any help. |
#2
|
|||
|
|||
"Randy Harris" wrote: My ignorance of pivot tables is causing me grief, I'd appreciate some help. At least I think I should be using a pivot table. On a worksheet I have a number of rows with 3 columns (Date, Name and Activity). I'd like to present that data in a pivot table with Name as the Row Heading, Date for the Column heading and Activity as the data. The wizard will only let me put a "Count of Activity" or "Sum of Activity" in the data field. How do I get it to just put the Activity code there, not a count or sum or any other aggregate. Thanks in advance for any help. the solutiion for ur problem will be after creating the pivot table go to the pivot table wizard go to layout double click on the tab in data field " sum or count of activity" in ur case u get a pop up box saying pivot table field which contains a name field where u can give any name u want. i hope that solves ur problem |
#3
|
|||
|
|||
If a data field contains blank cells, or cells with text, it defaults to
"Count of". To change the summary function while in the Pivot Wizard: Double-click on the data field button, e.g. Count of Activity Select a different function from the Summarize by list Click OK To change the summary function in the Pivot Table: Double-click on the Data field button, e.g. Count of Activity (if you have more than one data field, right-click on the field column heading, and choose Field Settings) Select a different function from the Summarize by list Click OK Randy Harris wrote: My ignorance of pivot tables is causing me grief, I'd appreciate some help. At least I think I should be using a pivot table. On a worksheet I have a number of rows with 3 columns (Date, Name and Activity). I'd like to present that data in a pivot table with Name as the Row Heading, Date for the Column heading and Activity as the data. The wizard will only let me put a "Count of Activity" or "Sum of Activity" in the data field. How do I get it to just put the Activity code there, not a count or sum or any other aggregate. Thanks in advance for any help. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
Help with pivot table
In PT-101 - I think something was said along the lines of:
The Data Area is designed originally and intended to summarize numeric data, and if non-numeric info is used you can only obtain characteristics like count and ?? hummmm maybe someting else, not sure what.. If I'm wrong maybe someone can correct me.. TIA, "Debra Dalgleish" wrote in message ... If a data field contains blank cells, or cells with text, it defaults to "Count of". To change the summary function while in the Pivot Wizard: Double-click on the data field button, e.g. Count of Activity Select a different function from the Summarize by list Click OK To change the summary function in the Pivot Table: Double-click on the Data field button, e.g. Count of Activity (if you have more than one data field, right-click on the field column heading, and choose Field Settings) Select a different function from the Summarize by list Click OK Randy Harris wrote: My ignorance of pivot tables is causing me grief, I'd appreciate some help. At least I think I should be using a pivot table. On a worksheet I have a number of rows with 3 columns (Date, Name and Activity). I'd like to present that data in a pivot table with Name as the Row Heading, Date for the Column heading and Activity as the data. The wizard will only let me put a "Count of Activity" or "Sum of Activity" in the data field. How do I get it to just put the Activity code there, not a count or sum or any other aggregate. Thanks in advance for any help. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#5
|
|||
|
|||
Help with pivot table
"Jim May" wrote in message news:Lst4f.1114$mV4.519@dukeread02... In PT-101 - I think something was said along the lines of: The Data Area is designed originally and intended to summarize numeric data, and if non-numeric info is used you can only obtain characteristics like count and ?? hummmm maybe someting else, not sure what.. If I'm wrong maybe someone can correct me.. TIA, This seems to be a limiting characteristic of the Pivot Table. I was not able to find a way to make it work. I went back to the original data source and created a Crosstab query. Unlike anything I was able to find in the Pivot Table, the Crosstab has a "First" selection, to use in place of Count, Sum, Avg, etc. The resulting worksheet lacks the "sophistication" of a Pivot Table, but is a lot better than nothing. Randy |
#6
|
|||
|
|||
Help with pivot table
You're correct. I interpreted the original question as meaning that the
Activity Codes were numeric, and a function other than Sum or Count was required. Jim May wrote: In PT-101 - I think something was said along the lines of: The Data Area is designed originally and intended to summarize numeric data, and if non-numeric info is used you can only obtain characteristics like count and ?? hummmm maybe someting else, not sure what.. If I'm wrong maybe someone can correct me.. TIA, "Debra Dalgleish" wrote in message ... If a data field contains blank cells, or cells with text, it defaults to "Count of". To change the summary function while in the Pivot Wizard: Double-click on the data field button, e.g. Count of Activity Select a different function from the Summarize by list Click OK To change the summary function in the Pivot Table: Double-click on the Data field button, e.g. Count of Activity (if you have more than one data field, right-click on the field column heading, and choose Field Settings) Select a different function from the Summarize by list Click OK Randy Harris wrote: My ignorance of pivot tables is causing me grief, I'd appreciate some help. At least I think I should be using a pivot table. On a worksheet I have a number of rows with 3 columns (Date, Name and Activity). I'd like to present that data in a pivot table with Name as the Row Heading, Date for the Column heading and Activity as the data. The wizard will only let me put a "Count of Activity" or "Sum of Activity" in the data field. How do I get it to just put the Activity code there, not a count or sum or any other aggregate. Thanks in advance for any help. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |