Resumen de Excel
Any time that you need to create a pivot table and report using the alternate calendar, you will copy this small worksheet into the workbook containing your sales data. Once you've established the relationship, you can build any pivot table using the year, season, quarter, month, week, or weekday fields from the Calendar table. When you release the mouse button, a fly-out menu appears where you can choose Fill Months to make the month-ending dates appear.
