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.