4

What is the method to obtain a count of unique IDs and a sum of their associated values in an Excel Pivot Table?

edit

• values

asked 2023-02-05 11:00:00 +0000

david
31 ●16 ●4

edit retag flag offensive close merge delete

add a comment

3

answered 2021-08-16 02:00:00 +0000

qstack
143 ●2 ●70 ●14

1. Start by selecting your data and inserting a pivot table.
2. Drag the unique ID column to the Rows area of the pivot table and drag the associated value column to the Values area.
3. In the Values area, click on the dropdown arrow next to the value and select "Value Field Settings."
4. In the dialog box that appears, select "Count" for the "Summarize value field by" option to get a count of unique IDs.
5. To get a sum of the associated values, select "Sum" for the "Summarize value field by" option.
6. You can also add additional fields to the Rows or Columns areas to break down the count or sum by other criteria if needed.
7. Once you have the desired count and sum, you can format the pivot table as needed and use it for analysis or reporting.

edit flag offensive delete link more

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss