Hi,
I have a data set that includes specific dates, showing sales transactions for each day of the month. I have put this data into a pivot so that the dates are showing as columns. What I want to do however is to show the date column data as a collation of everything for a specific month. For example, I want to show the total for a product for Jan 12, however now the data is showing as 1/1/12, 2/3/12, 3/1/12 etc as the data set, even though formatted to show month, is reading off specific dates during the month.
I have tried to find a way to group the data in the pivot so that I will get a total for Jan 12, Feb 12, etc. Is there a way to do this within the pivot???
Bookmarks