Hi,
Generating virtual tables from other tables is a typical matter of
databases. In Calc the data pilot is the most database-ish tool.
http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/DataPilot
Example:
http://user.services.openoffice.org/en/forum/download/file.php?id=8592
In a typical database the following query definition would generate such
a virtual table:
SELECT "Type", SUM("Amount") FROM "Table" GROUP BY "Type"
Hope this helps,
Andreas
--
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
