Good evening everyone,
I am looking for some help on the formatting of one of my pivot table.
The pivot table in the below example was designed to count the number of coins found in a month and determine the maximum found and average for that month. As it is currently displaying only the months are shown. If I select the "+" next to the month a date in the forum "dd-MMM" is shown. I would like the table to show the year, then within that year the month, then within the month the individual data from the day. What I am really interested in is the monthly stats. Currently, the stats for the months are shown, but it doesn't differentiate the year.
I will paste a screen shot of the area of interest. I will also attach the spreadsheet.
Any suggestions greatly appreciated.
Rob
Bookmarks