Privot table with condition

New Contributor



I have a Privot table with data from a query,


now i want to make a new privot table with a condition if the user inputs in cell A2 "F05" and column... from privot table its between a specified date then it has to show only these results.


is it possible to make a privot table with any conditions?


2 Replies
best response confirmed by allyreckerman (Microsoft)


You may query named cell, use it as parameter for the main query and return resulting pivot based on this

@Sergei Baklan 

Thanks for your answer!


I used the =Filter function on my query result with mulitple conditions