![]() ![]() You could then do the same for product 2, and product 3 until you have totals for all of them. You could, of course, look through the worksheet and manually add the corresponding sales figure to a running total every time product 1 appears. Say you have a worksheet that contains monthly sales data for three different products - product 1, product 2, and product 3 - and you want to figure out which of the three has been bringing in the most bucks. Comparing sales totals of different products. Here are seven hypothetical scenarios where a pivot table could be a solution: 1. ![]() They can be used to better understand, display, and analyze numerical data in detail - and can help identify and answer unanticipated questions surrounding it. The purpose of pivot tables is to offer user-friendly ways to quickly summarize large amounts of data. This is one of those technologies that are much easier to understand once you've seen it in action. If you're still feeling a bit confused about what pivot tables actually do, don't worry.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
February 2023
Categories |