This PDF is from my Calc workbooks, and covers Data Pilots, Calc's version of pivot tables.
You'll also need this lab file.
See also this post.
Cite This Blog
Train Your Organization
« Direct book sales are on again | Main | Persuading people that OpenOffice.org is the right choice? Accentuate the negative. »
August 21, 2008
TrackBack
TrackBack URL for this entry:
http://www.typepad.com/services/trackback/6a00d8341cdb1753ef00e554235f948834
Listed below are links to weblogs that reference Data Pilot (pivot table) tutorial for OpenOffice Calc:
Comments
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
OpenOffice.org 2 Guidebook
GetOpenOffice Consulting
Categories
- Administration and Installation
- April Fool's
- Calc
- Calc: 2008
- Calc: 2009
- Certification
- Charts
- Charts: 2008
- Clip art
- Clip Art: 2009
- Compatibility and Conversion
- Compatibility and Conversion: 2008
- Configuration and Setup
- Configuration and Setup: 2008
- Databases
- Databases: 2009
- Diagrams
- Draw
- Draw 2008
- Draw: 2009
- Education
- Envelopes
- Equations (math)
- Extensions
- Fonts
- Forms
- Free software
- General
- Grammar
- Graphics
- Graphics: 2008
- Graphics: 2009
- IBM
- Impress
- Impress: 2008
- Impress: 2009
- Labels
- Labels: 2008
- Libraries
- Linux
- Linux: 2008
- Macros
- Mail merge
- Mail Merge: 2008
- Mail Merge: 2009
- Memory
- Microsoft Office
- Microsoft Office users
- Microsoft Office: 2008
- Numbering: Headings
- Numbering: Lists
- Numbering: Page
- Open source
- Opendocument format
- OpenOffice
- OpenOffice books
- OpenOffice training
- OpenOffice.org
- OpenOffice.org 3.0
- OpenOffice.org 3.2
- OpenOffice.org: 2009
- Podcasts
- PowerPoint: 2008
- Presentations: 2008
- Printing
- Printing: 2008
- Products and Services
- Reader input
- Reports
- Reviews
- Spreadsheets
- StarOffice
- Styles
- Sun
- Switching to OpenOffice
- Tables
- TechTarget articles
- Templates
- Templates: 2008
- Thunderbird and Firefox
- Tips
- Training:free seminars and online training
- Ubuntu
- Web
- Web software
- Windows
- Writer
- Writer: 2005
- Writer: 2006
- Writer: 2008
- Writer: 2009
- Writing
I have a question about the formatting of tables resulted from DataPilot. When I change the filtering option I lost the color of the cell I have setted. So if I want the color and formatting I can't change the analysis on the same table.
Can you help me?
Thanks
Posted by: andrea | August 22, 2008 at 07:35 AM
Would love to get a screencast on this. This higher end solutions like goalseek, subtotals, Validation, detective are great when someone can see the whole process work.
Posted by: JZA | August 27, 2008 at 01:10 AM
Hi
I´ve a doubt. In MS Excel, i can save the "save data with table layout". The data from DB go to cache table.
Can I do it with OpenOffice? How can I do it if possible?
thanks
Posted by: Julio Verdi | October 03, 2008 at 02:31 PM
Very useful. Exactly what I needed.
I should note that I imported data from an Excel spreadsheet into OpenOffice, and could not get the pivot table feature to work. It turned out that the conversion had caused the data values to be a text field, which of course would not sum or average. So I had to convert the text numbers into number numbers. Then it worked 4.0.
See http://www.ambience.sk/open-office-text-number-format-conversion for a simple way to do this.
Posted by: David Tussey | October 09, 2008 at 11:19 AM
how could i repeat the rows data in datapilot
Posted by: Jawad | October 27, 2009 at 07:00 AM