{"id":235715,"date":"2024-07-03T01:49:44","date_gmt":"2024-07-03T01:49:44","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/?p=235715"},"modified":"2024-07-03T01:49:44","modified_gmt":"2024-07-03T01:49:44","slug":"how-to-show-value-instead-of-count-in-pivot-table","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-show-value-instead-of-count-in-pivot-table\/","title":{"rendered":"How to show value instead of count in pivot table?"},"content":{"rendered":"

When working with pivot tables in Excel, it is common to want to display values such as sums, averages, or other calculations instead of just counts. By default, Excel often shows counts of data in pivot tables, but it’s easy to change this to display the values you want. Here’s how:<\/p>\n

1. First, create a pivot table in Excel with the data you want to summarize.
\n2. In the pivot table, click on the field you want to change the summary type for.
\n3. Right-click on the field and select “Value Field Settings.”
\n4. In the “Value Field Settings” dialog box, you can choose from different summary functions such as sum, average, count, etc.
\n5. Select the calculation you want to display in the pivot table and click “OK.”
\n6. The pivot table will now display the selected value instead of the count.<\/p>\n

\n
\n

Table of Contents<\/p>\nToggle<\/span><\/path><\/svg><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n