Organization Hierarchy: using the value of one field as the heading for another.

Question

If the content of the field "Organization Hierarchy"."Level 01 Organization Classification" is "Division",

how can I use this content to be the column heading for "Organization Hierarchy"."Level 01 Organization Name"?

RVohra · Answer

OTBI does not support direct column-heading substitution from another column value.

However, I think you can try using a presentation variable populated via an EVALUATE SET VARIABLE expression and referenced in the column heading. Hope it helps!

Rich Merkel · Answer

Not sure exactly as the design goes…

but could you just create two columns

"Organization Hierarchy"."Level 01 Organization Classification" is "Division"

"Organization Hierarchy"."Level 01 Organization Name"

each has the column name you want to display.

Used advanced suppression, if

"Organization Hierarchy"."Level 01 Organization Classification" is "Division"

suppress the column

same on other column, just opposite way so it suppresses

"Organization Hierarchy"."Level 01 Organization Name"

if

"Organization Hierarchy"."Level 01 Organization Classification" is NOT "Division"

So in summary, create the two columns with two different headings, use avandced suppression on each column to determine which column you show in what scenario.

Maybe that can work.

gclampitt · Answer

You can't have a dynamic column name based upon data