SOLVED

Privot table with condition

Copper Contributor

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?

 

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@CasperMBOR 

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

 

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@CasperMBOR 

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

View solution in original post