set analaysis

[srinivasa1]

Hi ,

How I  Can pass Employee ID as parameters/variables ( in set analaysis expersion) dynamically based on current selection for Employee ID

See below.

=sum({<EmployeeID={'60171'}>}Sales

I would like pass employee ID as variables here based on selection

Thanks for any help.

[sunny_talwar]

Selection EmployeeID should flow through without you needing to specify anything. Have you tried Sum(Sales)?

[srinivasa1]

Thanks Sunny,

I need to pass EmployeeID  values as variables in set analaysis expersion

for have defined filed event  trigger   would like to store selected value in variable's then pass this into expression.

[sunny_talwar]

Can you may be elaborate why you need to do this? Are you restricting your expression using 1 to avoid any selections, but want to allow selection in EmployeeID field? For that, you can do this:

Sum({1<EmployeeID = P(EmployeeID)>}Sales)

or

Sum({1<EmployeeID = $::EmployeeID>}Sales)

[srinivasa1]

Thanks Sunny ,

My requirements us somehow different , I will try to crate sample example and send you ,

Basically am trying retrieve sales for Employee ID ='60171' when current selection of employee ID is '60560'

so am storing '60171' is in variable's then passing that variables into  set analysis expression .

Example as below  When I select employee ID ('60560')

sum({<EmployeeID={'60171'}>}Sales)

Thanks

[sunny_talwar]

Now this makes a lot more sense. So what is the logic behind selecting 60171 when 60560 is selected?

[srinivasa1]

Thanks Sunny and sorry for any confusion

I defined Filed event trigger based on current selection(60560) to store my calculated employee ID(60171) in variable's (var1) now I plan to use them in set analysis expression   see blow

sum({<EmployeeID={var1}>}Sales)

Thanks

[sunny_talwar]

Try this may be:

Sum({<EmployeeID = {'$(=var1)'}>}Sales)

or

Sum({<EmployeeID = {'$(=$(var1))'}>}Sales)