Menu
I'm trying to create a pivot table in Excel using the following data:
The end result I'm trying to come up with (using the pivot) is a summary like this:
However I can't figure out how to get Excel to count / add / consider all columns. I can create a pivot for each individual field/column, but can't figure out how to compile the data together.
605
Add an Additional Row or Column Field Click any cell in the PivotTable. The PivotTable Fields pane appears. You can also turn on the PivotTable Fields pane by clicking the Field List button on the Analyze tab. Click and drag a field to the Rows or Columns area.
The following limitations apply to pivot tables: You can create pivot tables with up to 500,000 records. You can add up to 20 fields as rows and 20 fields as columns.
Forgive the mac excel in the picture but here is how you can set up a pivot table.
Note though that the row labels will reflect only categories that are in the column you put in the row section
105
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
