extract data from pivottable which meets certain conditions

B

befuzzaled2010

What is the correct formula for extracting data from a pivot table report
which meets a certain conditional set of criteria?
 
G

Gary Brown

- You could use the Pivot Table's filtering options.
- In your original data, you could have a 'cheater' column with a formula
that meets your certain conditional set of criteria, include that column in
your pivot table data, put that field in the Pivot Table 'PAGE' area and
filter on it.
The formula would be something like...
If(A1>0, 1, 0)
and filter on the '0' or the '1' in the PAGE area.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Extracting data/using COUNTIFS 2
Extracting data from database into separate sheets 0
Conditional Formatting in Pivot tables 0
count cells in a table that meet multiple criteria 0
Looking for Information Word (Office 365) editing using VB.Net 1
IF OR AND in same conditional formula 2

Top