![]() ![]() Get a detailed report: How to update the data in an Excel PivotTable? ![]() To find out what data was used to get this value, double-click on the number “30”. But the work with PivotTables in Excel does not end there: capabilities of this tool are wide.įrom the report (see above) we can observe that there are 30 video cards sold IN TOTAL. You can output different parameters for analysis and move fields. ![]() Let's show, for example, the quantity of the goods sold. Summary report blank with Fields that can be displayed is opened. INSERT – PivotTables - specify the range and location - OK. As a result, we get one PivotTable from two tables. We transfer other data by the same principle."Multiply" the formula by pulling it down behind the lower right corner of the cell. Write = - pass to a sheet with the transferred data - select the first cell of a column that is copied. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |