Input Box doubt

[#1]

Hai Community Members,

Is their anyway to give value of a in input box and select that records in straight table of pivot table of charts. Thanks in advance

Regards,

ramesh

[kaushiknsolanki]

Hi Ramesh,

     You can do this.

     Consider this example. Say you have Employee_ID which user will be entering into variable say vEmployee.

     Then only thing you need to do is in chart expression.

     sum({<Employee_ID = {"$(vEmployee)"}Sales)

     Hope this is clear.

Regards,

Kaushik Solanki

[#3]

Hai Koushik,

Thanks for your response, I have done in the way you said, but unable to get the selected the date can you correct me.I have attached the sample. Please correct me

regards,

ramesh

[sarahallen1 · Accepted solution]

Remove your dimension =(vsid).  Remove your expression count(vsid).

Add a new expression:

only({$<SID={$(='s0'&vsid)}>}SID)

[#5]

Thanks Sarahallen , It is working amazing...

Regards

Ramesh