LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
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 Enda80 Excel Discussion (Misc queries) 1 May 3rd 08 10:52 AM
Pivot Field Data count Mónica Charts and Charting in Excel 1 April 19th 07 03:47 AM
change 'count of' to 'sum of' in pivot table field Rob B Excel Discussion (Misc queries) 2 July 28th 06 10:03 AM
Using a Pivot Table Calculated Field to get a Unique Count Mike Struckman Excel Worksheet Functions 1 November 22nd 05 05:32 PM
Count Intervals of Filtered TEXT values in Column and Return Count across a Row Sam via OfficeKB.com Excel Worksheet Functions 9 July 31st 05 03:37 AM


All times are GMT +1. The time now is 09:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"