One of the key features of the Pivot Table is the ability to sort results and see dynamic reports. Each label can be sorted and filtered by clicking the down arrow button next to the label header. You can then sort the list or filter it to only show specific entries. Your pivot table will automatically update as you modify the base spreadsheet. This can be great for monitoring your spreadsheets and tracking changes. . Pivot tables make it extremely easy to change the location and order of fields. Try dragging different fields to different locations to come up with a pivot table that meets your exact needs. This is where the pivot table gets its name. Moving the data to different locations is known as "pivoting" as you are changing the direction that the data is displayed. You can use a Pivot Chart to show dynamic visual reports. Your Pivot Chart can be created directly from your completed Pivot Table, making the chart creation process a snap.
आपके रिजल्ट को सॉर्ट या फिल्टर करें: आपकी स्प्रेडशीट को अपडेट करें: आपकी पायवट टेबल में बदलाव करें: पायवट चार्ट तैयार करें: