Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Amitesh - You can use the below expression.
='Product : ' & GetFieldSelections(Product) & 'Revenue Summary'
I hope this helps!
Cheers - DV
Put your application in order to take a look.
You can use the GetFieldSelections function.
Amitesh - You can use the below expression.
='Product : ' & GetFieldSelections(Product) & 'Revenue Summary'
I hope this helps!
Cheers - DV
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