Dynanic Trend Line

[#1]

Hi All,

I have completed adding all the buttons for territory, region and
area to show different charts respectively.

Scenario is if the Area is selected it needs to show all Area as dimension for the respective 4 weeks timeperiod selected.

Dimesion for linechart is Date and Area for this chart for example. The expression behind it is Num(Sum(TRx), '#,##0').

Territory list box as shown in mock up includes all the of the regions, area’s, territory’s and Sales Team for the user to pick individually.

Sales Team has values like Futura, Integra and ...

What I need to figure out is to show the black dotted line all the time on the charts to show the average TRx for the different Sales Team
selected irrespective of any button selections. Currently Futura Digestive Disease is showing per mock up, if
Integra Blue was selected should only show the Integra Blue Avg for TRx.

Users are allowed to Only select one Sales Team at all times.

Attached please find the image that I need to accomplish.

Any thoughts, idea or solution would be very helpful.

Thanks,

DD

[kaushalview]

Hi,

Regards

Kaushal Mehta

[Gysbert_Wassenaar · Accepted solution]

See attached example.

[#4]

Thanks a lot Gysbert, this is what I was looking for!

Appreciate your feedback and time!

Thanks,

DD