Do you want a trend line or a reference line?
Thanks for replying.
Sorry, I meant reference line, not trend.
No problem Burak. So I have a solution for you. You should first create a parameter Top x with 10 as the default value and Integer as the data type and then show the parameter control.
After that create a set of customers with Top x as the condition.
Then bring the set to the rows shelf and then right click on it and select show members in set. You will get a view like this...
Then you can add a reference line.
Now whenever you change the value of Top x then your reference line gets adjusted accordingly.
Let me know if any clarifications are required.
Thank you Kashish.
Exactly what I needed!
You are welcome Burak. Keep posting.