Portfolio Analzyer Count Calc

[RandyK]

I am building a portfolio analyzer view that will count the number of
projects within different groups (identified by a project outline code).
Having trouble finding the right MDX calculation for this (I am a new to
MDX). I thought it would be:

Count [project list].[project name] - but I am not getting anywhere... Any
ideas?

 

[Dale Howard [MVP]]

RandyK --

Are you using Project Server 2003? If so, I do not believe the Count
function is available in Portfolio Analyzer views. Instead, you must export
the PivotTable to Excel and you can use the Count capabilities of Excel
instead. Hope this helps.

 

[RandyK]

Hmmm - I was thinking that I could make a pie graph of how many projects are
owned by the different requesting groups (enterprise outline code)
--
Thanks much!
Randy

RandyK --

Are you using Project Server 2003? If so, I do not believe the Count
function is available in Portfolio Analyzer views. Instead, you must export
the PivotTable to Excel and you can use the Count capabilities of Excel
instead. Hope this helps.

I am building a portfolio analyzer view that will count the number of
projects within different groups (identified by a project outline code).
Having trouble finding the right MDX calculation for this (I am a new to
MDX). I thought it would be:

Count [project list].[project name] - but I am not getting anywhere...
Any
ideas?