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"?
You can't have a dynamic column name based upon data
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
suppress the column
same on other column, just opposite way so it suppresses
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.
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!
