Good evening everyone,
I have a model from powerpivot which its fact table has many colums. I wish to insert multiple pivot tables, each with unique columns. I know I can hide tables and columns from client tools, but this will hide the columns or tables I select for all the pivot tables I insert from my model. How can I hide specific columns and tables per pivot table so I can get each pivot table displaying only what I need so I can avoid overwhelming the final user with many columns per pivot table. If you have any questions, please let me know.
Thanks for taking your time to read my post.