![]() ![]() The "Quantity Sold" column identifies the number of the respective widget sold. In the image above, data is set up to list sales for two products: red widgets and blue widgets. The following image shows some test data that we'll use with the rest of this article. You could have a spreadsheet of a product sold by month. For instance, suppose that you have a list of products that sold each month. Pivot tables answer questions, so your test data should be able to feed into the question. Set Up Dataīefore you can practice with a pivot table, you need some data to use for the setup. You set up a table to answer one question, and then you "pivot" the table to answer a second question. Pivot tables allow you to answer several questions based on the same data. A pivot table lets you see a snapshot of data and then see the same data in a different snapshot.
0 Comments
Leave a Reply. |