In the attached workbook that I'm developing for a therapist friend, I have some income and expenses data in the "Line Items" sheet and my first attempt at a pivot table is in the "Report" sheet. Currently for simplicity sake I've only included the Income column and some of the expense columns.
Can I somehow change the pivot table's column "B" heading from "Sum of Income" to just "Income", and can I get a "Week Of 06 Nov" totals line similar to the "Nov Total" line between rows 11 and 12 (because they are different weeks) and a similar "Week Of 13 Nov" totals line between rows 14 and 15? Note that I have a "Week Of" value calculated on the "Line Items" sheet.
Pivot.xlsm
I see that you have code to refresh the PivotTable. I usually pu that code into the WorkSheet activate event
PivotTable-Grouped-by-Weeks-and-Mon.xlsx