Can we change Column Header Name Based on a Condition
Hi All,
I have a DFF in EBS Application which has 1 field. When the Country is "USA" the Field name will "CODE" and in case if the country is "MEXICO" the Field value will be "ADDITIONAL VALUE".
I'm trying to develop a BI Publisher report and will be pulling these 2 columns COUNTRY and the FIELD. So I want to dynamically change the RTF Column name based on the country. So when the country is "USA" the Column header name should be "CODE" but when the country is "MEXICO " the Column header name should be "ADDITIONAL VALUE".
Is it possible ? please suggest .