PIVOT TABLE

S

satya

G'day, I have a pivot table constructed. I have a column
with variable days. How can I configure the pivot table to
count number of days greater than 5 days?

I want to avoid adding extra columns with 1 (for meeting
criteria and 0 (for not meeting) as I want to also use
pivot to count number of days greater than 15 and 30 days

Appreciate your help

Satya
 

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

Excel does not accept text format! 0
List all tables, including document structure 0
Pivot table 0
Pivot Table Data Aggregation 0
Pivot Table Counting Text Data 0
Pivot Table Counting Text Issue 0
Pivot table Days to Months 0
Pivot Tables and Filter Criteria Display 0

Top