B
bridgirrl1
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.
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.