![]() ![]() ![]() We could use the Subtotal command to find the total for each salesperson, but we would still have a lot of data to work with. To answer the question what is the amount sold by each salesperson it could be time consuming and difficult because each salesperson appears on multiple rows. The spreadsheet below records sales from a company. To better understand pivot tables let's examine an example. Using Pivot Tables, you can view different summaries of the source data, display the details of areas of interest, and create reports. With this tool you can combine, compare, and analyzing large amounts of data easily. Pivot Tables are one of the most powerful and useful tools in Calc.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |