« 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?

The comments to this entry are closed.

GetOpenOffice Consulting

Get Book Resources

Search This Blog