Forum Discussion
Custom VIews--menu selection is grayed out-
If you have data in a Table on any worksheet, then the Custom Views is not available.
Maybe more accurately, FILTER can be used to accomplish it, but not in a straightforward manner. First, for the sake of clarity, I'm talking about the FILTER function, only available in the newest versions of Excel. Second, you would need to use FILTER several times in parallel, selecting the columns you want, omitting the columns you don't want. In other words, depending on the circumstances, two or more FILTER formulas would be written to create a dashboard's selective view.
I miss Custom Views.
I realise this is from a long time ago and we have all moved on over the past two years.
Just in case any one else seeks inspiration from this discussion, the headings on the output array can be used to generate the filter criterion
= FILTER(Table1, COUNTIFS(filterHeaders, Table1[#Headers]))