Eric58132
09-15-2009, 05:28 AM
I'm building a pivot table and we want to know, by town by day, the average number of times that an occurrance takes place. I have 3 fields: Town, Date and Account#(which is text and purely used for counting purposes). how do I arrange these to get the average count per day?
I've spent a lot of time trying to wrap my head around this and have even pulled in a couple other people because it seems like a very simple task...
can anyone help? thank you
I've spent a lot of time trying to wrap my head around this and have even pulled in a couple other people because it seems like a very simple task...
can anyone help? thank you