Allow users to choose columns from table to bookmark

[sharathm]

Hello,

          Currently, I have a table with around 250 columns of data and 50 users looking for different columns. Is there a way to allow users to bookmark a view with the columns that they are interested in from the table?

Please find below scenario.

Table in the report shows 250 attributes  Eg: Store Name, City, State, Address, Col4, ............... Col250.

User1 is interested to see data of Columns 1-10 only. 

User2 needs data of Col1, Col3, Col5, ......... Col250 only

...

User50 needs data of Col1, Col10, Col100, Col250.

How can respective user create their own bookmark with the columns that they need.

Note - Users needs to download data with relevant columns and share it with other teams. Instead of downloading all 250 attributes data and clearing off the columns that are not needed everytime is a tedious task, also creating individual report for each user and maitaining it (add/remove columns) is also a overhead, In this context, can we allow user to choose their own list of columns?

Regards,

Sharath

[DataUsurper]

A simple albeit possibly tedious way:

1. Identify which 'views' the users want as their preference
2. Create a table with those columns as those users' preference
   1. 
3. Then set that User as a clickable filter on the dashboard report which should dynamically update to each user's preference.

[sharathm]

Thanks @DataUsurper  for your response.

I'm afraid the user list cannot be maintained & also the mapping of user vs columns.

All the users are authorized to see entire data set and there should be an option to select/hide column on the fly.