Dynamic Column selection in BI Answers/views based on Prompt selections
SummaryDynamic Column selection in BI Answers/views based on Prompt selections
I need to have a BI Dashboard where the columns(eg, Brand) or group of columns ( eg, Company, Company site) have to hide/show in dashboard based on check box selections with Brand and Company respectively. I am able to pass the column header and formula based on selection through Presentation Variable in Prompts, but stuck with hiding columns when the respective check box in unchecked.
Thanks in advance for any help on how to achieve/proceed further.
Note: Using thin client modeler for building model. And my requirement is similar to the blog here