GREAT!!! Looks like that will do the trick, at least for single-level subtotals.
Thanks a lot! > -----Original Message----- > From: news [mailto:[EMAIL PROTECTED] On Behalf Of Andreas Saeger > Sent: Monday, July 31, 2006 7:05 PM > To: users@openoffice.org > Subject: [users] Re: Calc - copying subtotals without original data? > > Try a datapilot instead of a list with subtotals inserted. > The pilot can show aggregated results (Sum, count, avg,) with > and without details. It does not use formulas. It just shows > another representation of the source range or some datasource. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] For > additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]