This isn't necessarily the most useful way to show this data, so you might choose to collapse the date field to show only the names of the sales people and their overall sales.If you were to scroll down the pivot table, you would see each sales person listed in turn, with their sales by day as they are for Abdul. As you can see, we now have Abdul's sales first, with a row for each day on which he sold at least one product (dates on which he didn't sell anything aren't shown).The pivot table changes to look like this:.To do this, simply click on the Date label and drag it below the Salesperson label:.A simple example might be to show the rows by Salesperson and then Date, rather than the current layout of Date then Salesperson.To change your layout, the quickest way is simply to drag and drop fields between (or within) the different areas. You can use the Defer Layout Update option to stop excel rebuilding the pivot table layout every time you make a change to the field layout. That said, there may be a delay in updating the layout of your pivot table if you have a lot of data or a complex layout. Excel changes your layout almost instantly, so you can try different scenarios very quickly and easily. The great thing about pivot tables is that you can easily move fields around in the field layout to see whether a certain layout tells the story about your data that you want it to. The Pivot Table Field Layout is the key to understanding how you can change the layout of your pivot table. Changing the Pivot Table Field Layout - a simple example This lesson will focus on how you can change your pivot table layout using the Field List and the Field Layout panes. The Field list and Field layout for this pivot table looked like this: The resulting pivot table looked like this: In our first lesson, How to create a Pivot Table, we took a data table of sales data for three months and created a basic pivot table that showed daily sales over that time broken down by salesperson and by product sold. It also allow you to generate multiple reports from the same underlying data without having to create multiple pivot tables. This allows you to try different pivot table layouts so you can be sure your data is being grouped, aggegated and displayed in the most useful way possible. This Pivot Table lesson shows you how to use the Pivot Table Field Layout to quickly change the layout of your pivot table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |