« Open Source Resources | Main | More on the Data Pilot: Analyzing a Data Source/Database »

November 01, 2006


Tip: Right click in the "filter" box (located in cell A1) will alow user to change pivot-table without delete the new sheet (if the pivot table is created as a new sheet).


Wow, a really nice example. I now understand DataPilots :)

Hi Paul,

I'm glad it helped! They're a bit of a mindbender before you ee examples.


Hi Kingsa,

Thanks! I'll check it out.


can they be made to work with questionnaire type data where responses are yes/no and would need to be summed? Eg we know occupations as the first question, and would like to look at different frequency of responses by profession

To answer my own question. Yes, you can do this for questionnaire data. I chose to convert the yes and no data to 1s and 0s with a find and replace. then exported it to a database - this last step is probably not really necessary. But anyway, then I ran data pilot. Needs some further work to convert into percentages and for plotting ...

Previously I had done this by a series of sumproduct functions

what would be interesting would be whether it can deal with data in ranges.

Hi Stephen,

Thanks for posting the solution, I apologize -- I wasn't quite sure of the answer and have been on the road.


I was read your posting. Thanks you very much


I guess when you wish to have the average/sum/max/min of the Amounts in the column section, Open office snaps up. This is a convenient feature in Excel where you get to compare it with various values of the same parameter.

Any workarounds to this limitation ??


Hi Sajan,

I'm sorry, I don't follow -- could you clarify or expand on "snaps up"?


This is why I haven't bought your book yet. I refuse to do so until I can get at least one straight, clear, intelligible answer to a question.
Until then, it's Excel all the way. Its help files are about as murky as Open Office's, but at least there are dozens of books and millions of users.

When I followed the example you gave hear things didn't happen as you said they would. And if I have to spend fifteen or twenty minutes figuring out why, then what exactly is the purpose of coming to an expert's blog?

Please, I'm begging. Just one straight answer, one clear tutorial, and I'll happily contribute my $36.

Hi Dave,

Thanks for your comment. I have set up my blog to post all lessons from my workbook in a Data Pilot tutorial. See the posting that is now listed at the top of this blog post.

You can also see data pilot info here.

Hi Solveig
The example you gave helped a lot. I have a query if anyone can help me with it. In the case where there is ample of data in the spread sheets, and lot of it is repetitive data, is there any shortcut using data pivot to put them in desired order?


Thanks for posting the solution. Thanks! I'll check it out.

How can i include new rows in the existing pivot table?

Great stuff, thanks!

Really this work

Is there a way to group data with datapiots like with pivottables in excel?

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 saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

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.


Post a comment

Comments are moderated, and will not appear until the author has approved them.

Your Information

(Name and email address are required. Email address will not be displayed with the comment.)

GetOpenOffice Consulting

Get Book Resources

Search This Blog