Language Selection

English French German Italian Portuguese Spanish

OpenOffice.org Calc: Pivot tables by another name

Filed under
OOo

DataPilots are OpenOffice.org Calc's equivalent of what MS Excel and other spreadsheets call pivot tables. Under any name, they are a tool for extracting and summarizing the information contained in spreadsheet cells in a more convenient form. Using a DataPilot, you can immediately see relationships between different pieces of data that would be difficult -- if not impossible -- to find using formulas, and tedious to extract manually. In effect, a DataPilot gives you something of the power of using a database without actually switching out of a spreadsheet. Small wonder, then, that over half of spreadsheet users are said to use datapilots or pivot tables.

To understand the usefulness of DataPilots, imagine that you are a manufacturer selling Ogg Vorbis music players in the North American market. Your product comes in two colors, beige and black, and in 80, 150 and 300 megabyte sizes, and is sold in sales packs. For each sale, you record the number of display packs sold, and the total price. On a spreadsheet, some of your data might look like this:

More Here




Also: Pump up the Format Paintbrush with a double-click

More in Tux Machines

Absolute Linux Is a Lightweight Distro Based on Slackware 14.10

Absolute, an x86 Linux distribution based upon Slackware that concentrates on making sure that Internet, multimedia, document, and general home use works out of the box, is now at version 14.10 and is available for download. Read more

Future Linux Mint Releases to Have Other Colors Besides Green

Everybody knows that Linux Mint has a green theme and most people are able to recognize it from a glance because no one else is using it. It's become a sort of a trademark for it (not in the legal sense), but it looks like they are not happy with it or at least they are trying to appeal to other people who might not enjoy that green color. Read more

Deepin 2014.1, One of the Most Beautiful Distros in the World, Has Been Released – Gallery

Deepin developers have been hard at work on their new operating system and it looks like they managed to get a lot of fans. This system is one of the most interesting ones that have surfaced in the last couple of years. One of the reasons for its success is the implementation of a new desktop environment that is somewhat different from what other operating systems provide. Read more

Fedora 21 Will Try To Release Before Thanksgiving

Today was another FESCo meeting but fortunately no further Fedora 21 delay was announced today, but it could happen with the F21 alpha change deadline being today and the developers trying to get an approved build. Read more