Tellis chart with two dimensions and an average line of the first dimension

[pepe2209]

Hello

I have created a trellis chart with two dimensions:

1: quarteryear

2: client

I have expression avg(perfomance)

so each quarter is now a chart which shows the performance per client in bar-charts.

But now I would like to add the average performance per client independent of quarter over all the quarter charts as a line. The line should only respond to the second dimension (client) and not the firsl dimension (quarteryear).

So it should be the same line over all charts.

is this possible?

avg({1} performance) or avg(total(performance)) does not work.

your help would be much appreciated

regards

Peter

[Nicole-Smith]

Try:

avg(total <client> performance)