Chart Title

[upaliwije]

In a Chart title I want to show Chart Tile + Product  Extracted from  dimension field

Eg Achievement + Product A   This product A will be selected by user from a list box. Pls help me to do this Thanks

[Gysbert_Wassenaar]

Use an expression like ='Achievement ' & concat(distinct [Product], ' - '). This way if more products are selected they will be shown as a list of values separated by a - .

Just ='Achievement ' & Product will do fine if you always only select one product.

[upaliwije]

Thanks It is working. One more thing . I want it displayed in two rows   like

Achievement

  Product

Pls help me

[Gysbert_Wassenaar · Accepted solution]

On the Caption tab set the Multiline Caption option to 2 lines and use this expression: ='Achievement ' & chr(10) & Product