Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Remove your dimension =(vsid). Remove your expression count(vsid).
Add a new expression:
only({$<SID={$(='s0'&vsid)}>}SID)
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
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
Remove your dimension =(vsid). Remove your expression count(vsid).
Add a new expression:
only({$<SID={$(='s0'&vsid)}>}SID)
Thanks Sarahallen , It is working amazing...
Regards
Ramesh