Need Help?

[paulwalker]

Hi Community,

I have a Bar chart, Grouping dimension.

when i am click cycle/Drill group i want change caption.

if i am click Div---->  Division wise cost

Grade--> Grade wise cost

Status----> Status wise cost..

PFA,

[chrismarlow]

Start with;

getcurrentfield( [New Group] )

Then add some logic (a couple of If statements?) to get the display exactly how you want. 

[#3]

Hi

Paul, you need this windows title expression:

=if(getcurrentfield([New Group])='Div','Division wise cost',

  if(getcurrentfield([New Group])='Grade','Grade wise cost',

  if(getcurrentfield([New Group])='Status','Status wise cost')

  )

)

[stigchel]

See attached using GetCurrentField()

[#5 · Accepted solution]

Hi Paul,

as the guys have said get current field is your friend here, if you want to avoid nested if statements, the attached should work for you

hope that helps

Joe

[paulwalker]

Nice work Simmons....