C
CJSMILEY
I am looking for a way to get a count of projects sub-totaled by Business
Area and then by Business Department in project web access. I can get a
total count of all ITWR's (projects) in the database using the following
formula: Count(descendants([Project List])). However, the number of projects
does not reflect the filter or sub-totals that I am applying to the Portfolio
Analyzer view (Pivot Table). It reflects the total number of projects for
the entire pivot table.
Area and then by Business Department in project web access. I can get a
total count of all ITWR's (projects) in the database using the following
formula: Count(descendants([Project List])). However, the number of projects
does not reflect the filter or sub-totals that I am applying to the Portfolio
Analyzer view (Pivot Table). It reflects the total number of projects for
the entire pivot table.