Privot table with condition

%3CLINGO-SUB%20id%3D%22lingo-sub-2395695%22%20slang%3D%22en-US%22%3EPrivot%20table%20with%20condition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2395695%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20Privot%20table%20with%20data%20from%20a%20query%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Enow%20i%20want%20to%20make%20a%20new%20privot%20table%20with%20a%20condition%20if%20the%20user%20inputs%20in%20cell%20A2%20%22F05%22%20and%20column...%20from%20privot%20table%20its%20between%20a%20specified%20date%20then%20it%20has%20to%20show%20only%20these%20results.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eis%20it%20possible%20to%20make%20a%20privot%20table%20with%20any%20conditions%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2395695%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2396585%22%20slang%3D%22en-US%22%3ERe%3A%20Privot%20table%20with%20condition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2396585%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1065824%22%20target%3D%22_blank%22%3E%40CasperMBOR%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20query%20named%20cell%2C%20use%20it%20as%20parameter%20for%20the%20main%20query%20and%20return%20resulting%20pivot%20based%20on%20this%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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

@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