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 |
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 |
All times are GMT +1. The time now is 08:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com