Customizing a 'Total' label

Question

Hi,

I am using OBIEE 12.2.1.2.0

I would like to know is there a way to set a custom name in Total labels,

but not in the way that it has a label that is the same throughout analysis but in the way that it has

dynamic name like  Totals by (value of the column)

For example if the column name is Store 1

My Total should be Total by Store1

Thx, Matija

Robert Angel · Answer

Assuming tabular analysis in the results tab / layout you can set Total After on columns and measures; -

Click on Format Labels; -

Make the caption what you need.