![]() You can see the detail rather than the sum or average if you double-click the name of a field. I'm going to choose Average for this example Here, I double-clicked the Sum-Amount field to get other function options. Here are the results you get with that setup. I specified that no total for rows or columns should be included, and that the results be put in Sheet2 in the upper left corner. As you can see the More section is displayed with different options. Select a different value in the dropdown list and you get different results. The Store window in the Page Fields area will give you a dropdown list so you can view all values, or one value at a time for the category in the Page Fields area.Ĭlick OK and you get these results, with the option to use the dropdown list. NOTE: Click any of these images to see a bigger version.Ĭlick the Filter button and you can filter things out more - say, just view invoices that are more than $5000, or whatever you like. I'll show you a few examples: the setup, and what the data results look like. When you have things the way you want them, just click OK. Just drag the fields where you want them, and click More to have more options. Here's the window you'll be working with. Choose to use the current selection, then click OK.ĥ. Don't select the data you don't need to.Ĥ. Click in the upper left corner of the data. (Don't worry if your numbers are a little off from the screen shots-I tweaked it a little along the way.)Ģ. Download this file, datapilotspreadsheet, if you want to use the same spreadsheet I've used. I'm including a lesson here on how to use the data pilot. You start off with raw, plain old data, not data that you've already summed up. If you haven't used them before, it's just a bit of a mind-bender to get started-it's all about the data that you start off with. Data Pilots are the OpenOffice Calc equivalent of pivot tables.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |