Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table
Excel 2007 PivotTable
Value Filter http://c0718892.cdn.cloudfiles.racks.../06_04_10.xlsx Pdf preview: http://www.mediafire.com/file/fzgwmdetvmt/06_04_10.pdf |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Pivot Table and Pivot Table dates are not in correct order | Charts and Charting in Excel | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) |