Change style of total line

[#1]

Hi all,

Wonder if anyone can help me with this one...

Using Qv11, on a line chat, I created a Total (Dimension Limits) wich I called 'Average'.

Now I wanted this 'Average' line to have a diferent style, so I inputed this formula into the Line Style of the expression:

=if(Source<>'Average','<S1>','<S4><W4>')

It doesn't work.. but if instead of average I put any other value of the field Source, then it works fine.

How can I make it work for the Total (Dimension Limits) created line?

Thanks you so much...

Kind regards,

Nuno

[#2]

heyy

Try Using Total (Dimension Limits) instead of ' Average' in your expression

something like this

=if(Source<>',Total (Dimension Limits)'<S1>','<S4><W4>')

[#3]

Seriously... when I say Total (Dimension Limits) I mean enabling Show Total on Chart Properties, Dimension Limits pane.

Can anyone help?

[Gysbert_Wassenaar]

You can use the rank function. The Others category will always have rank 1. Suppose your expression for the line values is avg(Amount). Then you can set the color of the Total line that's created by enabling the Others option with: if(rank(avg(Amount))=1,red()).

[#5]

Thanks.. but it didn't work. Rank 1 doesn't point to the Total line (or the Other line) using your suggested method.

[Gysbert_Wassenaar · Accepted solution]

Ah, the Total option. Ok, try if(isnull(Source), '<S4><W4>')

[#7]

That did the trick.... Thanks!

[rwunderlich]

Excellent solution Gysbert!

-Rob