Question Hide fields(table columns) from Pivot table Fields

[alexholly]

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.

 

[Matt Allington]

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.

it can't be done. If you are producing the pivot for the user, and if they are the type of user that would be over whelmed, then just hide the fields list - they probabaly will never know how to make it visible again.