Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
88
Views
Topic starter
Excel 2019. I have a workbook with a pivot table. The data source is a power pivot query to a SQL server view. I filter the data by the Payment Year number column.
Is it possible to have the value for this pivot table filter set from the contents of a named cell?
Posted : 08/12/2020 5:56 pm
Hi Paul,
Select that cell, press Ctrl+T to create a table.
You can load a table directly in Power Pivot, a named cell can be loaded through power query into the data model.
Posted : 09/12/2020 12:30 am
