Hi,
I have a powerpivot pivot table with 1 filter set up to exclude a particular item. This works fine until i refresh my data and the new items are excluded.
In regular excel there is a workaround for this - 'include new items in your manual filter'.
Is there an equivalent for Powerpivot?
Thanks
I have a powerpivot pivot table with 1 filter set up to exclude a particular item. This works fine until i refresh my data and the new items are excluded.
In regular excel there is a workaround for this - 'include new items in your manual filter'.
Is there an equivalent for Powerpivot?
Thanks