I have large pivot table which contains data i would like to summarize.
In the attached you will see an extract from my pivot table on the left and the results i would like to achieve in the bold boxes on the right of the worksheet.
The 03 and 04 in column A are the months of the year eg March and April.
The 1, 2, 3 in cells C2, D2, E2 are the days of the week. These days go out to maximum 31 days.
Column B are invoice numbers
and column C,D,E,.. are the associated invoice $ value.
What i would like to do is count how many invoice there were on each particular day of each month.
For example on the 01/03/13 there were 7 invoice. 02/03/13 there were 9. 01/04/13 there were 9.
The end report i would like the data in future months to show 0 or - and when the pivot table is refreshed in future and that information becomes avaliable i would like it to automatically appear in the report.
I have found that using the count formula is easy enough but i can work out how to incorporate the month column into my formulas so that i can fill out my report and have it update as each month passes.
Any help would be greatly appreciated. Let me know if my explanation of my problem needs further explanation.