May 28 2021 06:31 AM
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?
May 28 2021 10:35 AM
SolutionYou may query named cell, use it as parameter for the main query and return resulting pivot based on this
May 31 2021 03:12 AM
Thanks for your answer!
I used the =Filter function on my query result with mulitple conditions
May 28 2021 10:35 AM
SolutionYou may query named cell, use it as parameter for the main query and return resulting pivot based on this