So there is no way for the pivot table to automatically do this for me? I
have dates in column A of my data sheet. In the pivot tables, excel just
reads these dates and automatically groups them by month, quarter, or year.
There is no way to do this for days of the week, correct?
In Column B I have Day; In Column C I have Month, In column D I have Year;
I just created a Pivot Table and grouped by: Month in Row and Year in
Column. Then, I put Count of Day in â€˜Data Itemsâ€™. You can do pretty much
whatever you want to do with Pivot Tables. If it doesnâ€™t you the desired
results, change you r DATA! The Pivot Table is built off of the DATA. You
DATA may not beâ€¦atomicâ€¦meaning smallest possible unitsâ€¦and thus your Pivot
Table may not give you your desired results. Again, try to manipulate your
DATA, and then manipulate your PIVOT TABLE.