F
fmckinnon
Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Hey Gang,
The Short story:
Want to be able to have the same "subtotals" options (ie. at each change in "DATE" use function "SUM", summary data below, etc) that are available to me in Data > Subtotals, but within a List Manager. (The Data > Subtotals feature is greyed out in List Manager)
Details:
I hope someone can help me figure this out. I've got an ongoing list that requires the use of List Manager. (it's an ongoing list of orders and net P&L, and I often use the list manager sorting features to display ONLY the rows from certain vendors, etc).
Without List Manager, I can choose "Subtotal" from the Data menu and have the option to display the subtotal by date, under each date. This is great, and exactly what I want.
However, with List Manager, I can only go to the "show totals" line, and choose the "Sum" function to show a total at the very bottom.
I'm pretty sure it's possible to make the "at each change in DATE, use function SUM" formula ... but I have no clue how to do it. When I look at the actual formula, it just looks like a SUM formula of all the cells. I have no clue where the information is that makes it display as daily subtotals - there are options like "display totals underneath data, page breaks, etc".
Thanks in advance.
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Hey Gang,
The Short story:
Want to be able to have the same "subtotals" options (ie. at each change in "DATE" use function "SUM", summary data below, etc) that are available to me in Data > Subtotals, but within a List Manager. (The Data > Subtotals feature is greyed out in List Manager)
Details:
I hope someone can help me figure this out. I've got an ongoing list that requires the use of List Manager. (it's an ongoing list of orders and net P&L, and I often use the list manager sorting features to display ONLY the rows from certain vendors, etc).
Without List Manager, I can choose "Subtotal" from the Data menu and have the option to display the subtotal by date, under each date. This is great, and exactly what I want.
However, with List Manager, I can only go to the "show totals" line, and choose the "Sum" function to show a total at the very bottom.
I'm pretty sure it's possible to make the "at each change in DATE, use function SUM" formula ... but I have no clue how to do it. When I look at the actual formula, it just looks like a SUM formula of all the cells. I have no clue where the information is that makes it display as daily subtotals - there are options like "display totals underneath data, page breaks, etc".
Thanks in advance.