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

Dates In Excel 5
Doughnut Chart linked with the slicer in the pivot table 0
Dealing with a Pivot Table (when I don't want to) 0
Power Pivot. Yikes. 0
Pivot Table Counting Text Data 0
Write back from pivot table 1
Write back from pivot table 0
VLOOKUP a Pivot Table Filter 0

Top