Number of projects in each state?

Hi,

I have Cube that manipulating projects information with following dimensions:

1- Year

2- Project Name

3- Executing Department

4- Project State (e.g. Initiation, RFP, Tendering, … )

In the Cube, I want to display the number of projects in each state using Calculated field, or any other suggestion.

Thanks.

I'm not sure if I understand your problem, but you should be able to add a count measure to your measure group (it should do this by default).

If this doesn't answer your question, could you describe a little more about exactly what problem you are encountering?