Hello,
I have a pivot table with Months and Weeks as row headers and Members and Enrollees as column headers. The weeks collapse into the months. I have two problems. 1) I need the month totals to show up all the time instead of only when the weeks are collapsed. 2) For members I need the summary to show the most recent weeks data and the enrollees to sum up the weeks. I can't find any way to create custom summaries. All I see are the standard summary functions. please help. Thanks.
I have a pivot table with Months and Weeks as row headers and Members and Enrollees as column headers. The weeks collapse into the months. I have two problems. 1) I need the month totals to show up all the time instead of only when the weeks are collapsed. 2) For members I need the summary to show the most recent weeks data and the enrollees to sum up the weeks. I can't find any way to create custom summaries. All I see are the standard summary functions. please help. Thanks.
