Hi there Karthik,
What you need to do is create a parameter to act as the filter on your worksheet and then a separate calculated field to control this parameter.
I have done an example using "Superstore Sales Training" but you can easily apply this to your worksheet. First of all create a parameter to contain your "Stores", in my example I have used Region as the separate lines.
Then we must create a calculated field to contain the seperate calculations for the future reference line:
You can see this calculation will look for the parameter selection and then the Region (Store in your case) and return the Sales. This is what we will use on our reference line value:
Right click on the parameter and select "Show parameter control" and you will now be able to filter between the reference lines.
I have attached the packaged workbook and if you have any further questions please ask. Hope this helps!
RefLine2.twbx 1.2 MB
Hey thanks Will for the response. I looked into your solution and referring some other links. Trying to achieve using Table calculations. Will post the updates.