Note: This works in regular Excel, not in Power Pivot and it works with calendar, not fiscal dates. Let say that you’ve got refreshable Excel reports working in GP, but your data is by day. That can be challenging to deal with in a pivot table…or not. One option if you are using calendar months […]