Display Individual Dimension and Average on same graph

[#1]

http://community.qlik.com/forums/t/19723.aspx

Hello, how would you represent those data on the same graph, both:

- on X axe: time (here year)

- on Y: several curves showing

- the sales for each customer

- the average for each year

I am trying to find a solution on this kind of topic without success

Thanks you for your help,

Bruno

[Anonymous]

This you can try : Copy and past the expression and adjust the new expression in something like this:

(Sum (Sales) /Count (Distinct Year))

[#3]

Hello, thanks for your reply but I am still having an issue with the "dimension" i need to use in the graph.

What should be the right parameter to use in "dimension" - i guess Year ? what's about customer which is my 2nd axe of display & analysis for the average value ?

Thanks

Bruno