Average Over Time by the Department of the selected Dimensions
I would like to create a line chart which has
Year-Month as dimension and
measures are Profit Ratio (of Current Selection) and
Average Profit Ratio for the Department of the selected Product at that point in time (for each of the Month).
When a User selects a Product/Employee the chart should display the Profit Ratio over time along with the average Profit Ratio of the Department over-time so it will be easy to compare data in the same chart.
Profit Ratio = Sum(Income) / Sum(Sales)
The Department average shows the Overall as a single dot instead of showing a line chart Over Time.