Using set expression in a graph dimension

[#1]

Hi everybody,

I have a graph with time as dimension and the following formula as expression:

count(DISTINCT

                    {$

                     <

                          Project=

                         ,[Project Type]=

                         ,[Project Category]={"Execution"}

                         ,SA_PER_ORG_P={"EMP"}

                       >

                        +

                       <

                          [Project Category] = {"Potential"}

                          ,SA_PER_ORG_P={"EMP"}

                        >

                     } 

        EMPLID_RD)

The formula counts the distinct Employee ID  considering the intersection of the two set defined in the set expression (red and blue).

I need to display a table (pivot table, linear table) with the list of the distinct emplid counted in the formula for a single month, with their properties. 

Due to set expression in the formula, the list of possible EMPLID (white EMPLID) is different from the list i would like to obtain. 

Do you have any suggestion to obtain my target list?

I tried to use set expression as dimension of a graph but it didn't work.

I thougth to use alternate state, but i can simulate only one of two state defined in the set expression.

Thanks in advance,

Giampaolo

[v_iyyappan]

Hi,

Use this expression like this

count( {$ <  Project=,

               [Project Type]=,

               [Project Category]={"Execution","Potential"} ,

               SA_PER_ORG_P={"EMP"} > } 

     DISTINCT   EMPLID_RD)

Regards,

Iyyappan

[#3]

Hi,

The problem is not in the expression, it works fine.

I need to display the list of EMPLID counted by the Expression.

Thanks,

Giampaolo

[#4]

Hi everybody,

Somebody has any idea?

Thanks

Giampaolo