Hi

I'm using the "Portfolio Analyser", an analysis tool provided as part
of MS Project Sever, which allows the user to create graphs and pivots
on the back of a custom built Project Data OLAP cube.

What it will additionaly allow you to do is create custom formula
(based on MDX Expressions) against the measures.

I need to create a formula that will logically return the following
and have no idea how to do it.

Measure - Work (Stored in hours)

QRY - Filter for Project x and Count( each day in time period if work
is greater than 0)

Info Req -
Jan Feb Mar
Project x 20 18 22
Project y 20 18 22
project z 20 18 22

If there are any good info. sources for this sort of basic info could
you please post them

Thanks...

Duncan