Forum Discussion
PaulMBACB
Nov 30, 2023Copper Contributor
"Include new items in manual filter" greyed out if the field is in the filter area of a pivot table
I'm using Excel in Office 365. I have a pivot table where one of the fields in the source data can change over time (new products being added). In my pivot I need to exclude just one product, so I ha...
djclements
Nov 30, 2023Silver Contributor
PaulMBACB Sorry, I'm not able to test Power View with an OLAP query on my system. You could pass my suggestion on to your IT guy and see if it's feasible, or wait for someone else to reply here.
Best regards.
PaulMBACB
Nov 30, 2023Copper Contributor
OK - thanks