Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot tbl rpt-how to return text in a field vs. a sum/count value
New to pivots & discussion groups - please be kind!
Trying to use a pivot report for scheduling. On the spreadsheet I have columns for calendar days and another column called projects. Each row on the sheet will have a project name in the "projects" column and the volume for the project is entered & repeated in the columns for each calendar day the project is planned to run. Want to be able to show all of the project names that are planned into each Calendar day but also want to see only the projects names planned for each day. I have all of the Calendar columns in the row area of the report and I was hoping there might be a way to return the text in the C&F field for each of these calendar columns? Expect to have several hundred projects planned over a few months. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot tbl rpt-how to return text in a field vs. a sum/count value
Hi
I am finding it difficult to visualise your source layout, and what you are trying to achieve. If you want to mail me direct with a copy of your workbook, I will see if I can help. To mail direct, send to roger at technology4u dot co dot uk Do the obvious replacement of at and dot to give a valid email address. -- Regards Roger Govier "bridgirrl1" wrote in message ... New to pivots & discussion groups - please be kind! Trying to use a pivot report for scheduling. On the spreadsheet I have columns for calendar days and another column called projects. Each row on the sheet will have a project name in the "projects" column and the volume for the project is entered & repeated in the columns for each calendar day the project is planned to run. Want to be able to show all of the project names that are planned into each Calendar day but also want to see only the projects names planned for each day. I have all of the Calendar columns in the row area of the report and I was hoping there might be a way to return the text in the C&F field for each of these calendar columns? Expect to have several hundred projects planned over a few months. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
Pivot Field Data count | Charts and Charting in Excel | |||
change 'count of' to 'sum of' in pivot table field | Excel Discussion (Misc queries) | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |