I have a Bar Chart in QS.
I like to add one more line to this bar chart , which show the average yearly sales. avg(sales)
May be using a combo chart
what i need is to have the average line on the chart .
For example if i select year = 2016 , total amount of sales 1,586 , Average = 1,541/6 = 256.
May i know how to do it ?
Retrieving data ...