Multi-line chart with an average line

[nagaiank]

Hello friends,

I need to create a multiline chart with an average line for the following data.

If a state with n cities is selected, the chart should display monthly sales trend for each city in that state and an additional (n+1)th line showing the average monthly sales trend of the n cities. (For example, if IL is selected, the multiline chart will have five lines, one for each city and the fifth line showing the monthly average sales of the four cities.)

I have data in a table in four fields: state, city, month,sales.

What are the dimensions and expression(s) to be defined for the chart?. Appreciate any help in achieving this.

[#2]

Hi,

Check Marco Wedel's answer in this thread:

Add the average line to a line chart with multiple lines

[nagaiank]

Thank you for your response.

I did go through Marco Wedel's  post and would have used the solution, if I were to start with selection of cities. As I have to select state in my case and display lines for cities, the use of GetFieldSelections() is not an option.

[#4 · Accepted solution]

I see.

Can you try replacing the getfieldselections with this:

'$(=concat(distinct city, chr(39) & ', ' & chr(39)))'

[nagaiank]

Thank you. It worked.