Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hi,
try the getcurrentfield() function
Returns the name of the currently active field in a group.
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.
hi,
try the getcurrentfield() function
Returns the name of the currently active field in a group.
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.
Can you upload a test document so that we could see what you are trying to achieve.
Thanks,
Byron
Hi,
this is my file,
if i select Cyclic dimession Service it si working fine but nor OR...
Thanks.
Thanks pat.agen,
It is working fine..