This video covers how to create column fields, which are just one more way to add a condition to your PivotTable.
- [Instructor] Pivot tables can give you…very specific insights on your data,…and one way to do that is with column fields.…In this pivot table,…you can see I have a row field for months,…and then I have the value field for sum of amount.…Now I'm going to add a column field…by dragging the type field down to columns.…And then I'll scroll over to the right a little bit…so you can see the whole thing.…Now you can see we have that row field of months,…and we have column fields that are dividing up…that sum of amount field.…
In this case, it works pretty good.…I have got the months here,…and then inside each month I can see…how much was spent on each category of purchase.…You can also add secondary column fields…like we did with secondary row field.…So I'm going to go ahead and I'm going to drag the buyer…under the type field here in the columns area.…And I'm going to have to really scroll this time…to see everything.…And you'll see that what happens is…that each month of transactions are separated by type,…and then under type by the buyer.…
- Describe when you would use a PivotTable.
- List the things you need to do prior to creating a PivotTable.
- Explain the benefits of creating an Excel table before creating a PivotTable.
- Describe a conceptual representation of the value field.
- Cite the reason you should periodically refresh a PivotTable.