Field Value in Chart Title

[#1]

Hi,

I want to display name of the Product that I'm selecting in a list box on the title of a chart.

My chart has a dimension Qtr Year ( calculated by Qtr&' '&Year)  and a measure Revenue. I select a product and a year and the chart is supposed to show Revenue for the selected Product for all the quarters of the year. I have done that.

Now the Chart Title. Presently it is a static string 'Revenue Summary by Product' I want it to say 'Product X Revenue Summary' where Product X is dynamic and changes based on the selection made in the Product Name list box.

Is it possible to do so?

[Anonymous]

Put your application in order to take a look.

[#3]

You can use the GetFieldSelections function.

[IAMDV · Accepted solution]

Amitesh - You can use the below expression.

='Product  : ' & GetFieldSelections(Product) & 'Revenue Summary'

I hope this helps!

Cheers - DV

[#5]

Hi DV and ehilsinger,

Thanks to both of you for helping me out. Sorry I could not mark both your answers as correct.

I'm a new to this so DV's complete syntax helped more.

Thanks again for the prompt replies.

Amitesh