![]() ![]() In its present state, this pivot table is not that fascinating it is telling you that exactly one record in the database has a total revenue of $23,990.įIGURE 4-50 If you fail to include the Year field in the grouping, the report mixes sales from last January and this January into a single row called January. When you put a text field in the Values area, you get a count of how many records match the criteria. A text field-Customer-is in the Values area. The numeric field-Revenue-is in the Rows area. The pivot table in Figure 4-42 is quite the opposite of anything you’ve seen so far in this book. This can be useful for creating frequency distributions. The Grouping dialog box for numeric fields enables you to group items into equal ranges. You can use the Power Pivot grid to define a hierarchy so you can quickly drill down on a pivot table or chart. Text entries can be grouped into territories. Numbers can be grouped into equal-size buckets. You can roll daily dates up to weeks, months, quarters, or years. Pivot tables have the ability to do roll-ups in memory. Grouping and creating hierarchies in a pivot table
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |