Pivot Table

K

KTR

I have a pivot table based on an excel worksheet with five columns - Date,
Call From (Names), To, Time, and Type.

In the pivot table, i am using From for the rows. I also use From in the
values area as i want to count the number of times the data in From appears -
as there can be repeats. Next, I want to use Time as it relates to Call From.
Time ranges from 0 to > 0. I want to specifically count how many 0s and
greater than 0s. i thought i could filter for the data after adding the Time
field to the data area - it allows a filter but the results do not change.

I am using Excel 2007. I hope this makes sens
 

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

Data Lookup Question 1
2003 Pivot Table Filter (items dropped in the Page Fields) 1
Pivot table filter list - listing irrelevant subcategorys 1
date filter in a pivot table 1
Pivot Table Data 2
Access #Error & Excel Pivot 0
Pivot Table Data Sum/Count 6
Pivot Table - Changes 5

Top