Yes, you can definitely show both count and sum data in the same pivot table. Here's how you can do it:
- First, create a pivot table with your data column in the "Values" section.
- In the "Values" section, you will see the name of your data column. Right-click on it and select "Add to Values" again. This will add a second copy of the same data column to the pivot table.
- Now, you will have two copies of the same data column in the "Values" section. Click on the drop-down arrow next to the first copy and select "Count". This will show the count of entries in that data column.
- Click on the drop-down arrow next to the second copy and select "Sum". This will show the sum of values in that data column.
- You can now see both count and sum data in the same pivot table.
Note: If you want to change the order of the count and sum columns, you can simply
drag and drop them within the "Values" section of the pivot table.