Forum Discussion
Solved
Privot table with condition
Hello,
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?
You may query named cell, use it as parameter for the main query and return resulting pivot based on this
2 Replies
You may query named cell, use it as parameter for the main query and return resulting pivot based on this
Thanks for your answer!
I used the =Filter function on my query result with mulitple conditions
