Use the value of dimensions in The Expression

[jixiaoquan]

Hi everyone,

     I have a problem,in the expression I want to use the value of the first dimension,but it does not work.

     In the straight table,there is a dimension and two expression.The dimension is a drill-down group named "COM_Drill".One expression count "EMPL" and the other is count the "EMPL" which the Name equals the value of the first dimension(drill-down group).

    

     The source:

   

[tresesco]

Like this?

=Count({<Name={"=Name=$(=GetCurrentField(COM_Drill))"}>}DISTINCT EMPL)

If not, please explain your expected output.

[crusader_]

Hi,

Actually I can't get your expected result?

In your set analysis you're trying to compare Name with Group.

Group contains only Names of fields, but not their content. To see current field in group you can use GetCurrentField() function.

Please make in Excel expected result table it helps others correctly understand your requirements.

Regards,

Andrei