Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to conditionally hide a column based on a parameter value in BI Excel Template?
We have a requirement to dynamically hide a column in the excel report based on what input parameter the user selects. . I am guessing it should be done using <xsl: if test…?> clause, but not sure of. Need some inputs on this.
Answers
-
Thanks for using Oracle Communities.
Yes, you can use the if condition to hide the same . Refer below MOS doc -
Display or hide columns depending on the parameter selected (Doc ID 2539753.1)
Regards,
Arjun
0 -
Thank you for replying @Mallikarjuna Kuppauru-Oracle. This looks like the code to be used in rtf template. My requirement is in an Excel template.
0 -
Conditional formatting is not supported in excel templates as its done for RTF. You will have to go via RTF route for conditional formatting requirements.
1 -
Thanks for your response @Abhilash K - Deloitte USI .
0
