Dynamic reference lines Based cyclic group dimension.

[#1]

Hi,

I need to show standared deviation in chart .For that iam caluculating an  expression in reference lines option and showing.

for singel dimesion it is working fine.

but my requirement is cyclic dimession for this chart.

based on selected filed that expression has to caluculate...

any help.....

Thanks.

[pat_agen · Accepted solution]

hi,

try the getcurrentfield() function

getcurrentfield ( GroupName  )

Returns the name of the currently active field in a group.

Example

getcurrentfield( myGroup )

you can then write an if clause and change your expression depending on the field

=if(getcurrentfield(CyclicGroup)='xyz',sum(abc),

  avg(efg))

hope this helps.

[#3]

Can you upload a test document so that we could see what you are trying to achieve.

Thanks,

Byron

[#4]

Hi,

this is my file,

if i select Cyclic dimession Service it si working fine but nor OR...

Thanks.

[#5]

Thanks pat.agen,

It is working fine..