Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data in my pivot table changes to zeros
I have created a pivot table using a dynamic named range as my source. The source data consists of 52,416 rows and 10 columns showing: Membership code Date Hour Day Week Month Term Year Checkouts Checkins Everything appears as expected when I go through Excel's PivotTable wizard but the -Sum of Checkins- and -Sum of Checkouts- (which I place in the data area of the PT) always come up as zeros. The PT seems to have replaced all the correct data in each cell with a zero! In addition, I have to manually change the fields to "-Sum of-..." as opposed to the "-Count of-..." that appears first. It feels as though this screwy behaviour must have a bearing on why all my data is being replaced with zeros. I should add that this has never happened to my other PTs. In fact, I have a PT in the same workbook with exactly the same columns and layout with a similar amount of data that works perfectly. I just can't figure it out! -- MyrtlePeacock ------------------------------------------------------------------------ MyrtlePeacock's Profile: http://www.excelforum.com/member.php...o&userid=29812 View this thread: http://www.excelforum.com/showthread...hreadid=495192 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exclude pivot table data from pivot chart? | Charts and Charting in Excel | |||
pivot table | Excel Discussion (Misc queries) | |||
How to show data greater than 10 in pivot table | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) |