Need to display columns dynamically.

1482472

Hi..

I got a request to display columns in reports based on the column value. Please see the below example you will able to understand.

Tab 1 :

     Feature 1

     Feature 2

Tab 2:

     Feature 1

     Feature 2

      Feature 3

Tab :

     Feature 1

     Feature 2

   

We got main report  with below columns

Date | Tab 1 | Tab 2 | Tab 3

Upon clicking any of the tab name should display, below report as

if tab 1 clicked,

Date | Tab 1 | Feature 1 | Feature 2

if tab 2 clicked,

Date | Tab 2 | Feature 1 | Feature 2| Feature 3 .

if tab  3 clicked ,

Date | Tab 3 | Feature 1 | Feature 2

How to restrict column based on column value.

[Deleted User]

If Feature 1 | 2 | 3 are columns then one choice is to use conditional navigation action links (Navigate to BI content):

Alternatively you can also simply create 3 different views containing the column selections you mentioned above and then put the three into a  View Selector...