Most of the time when people see a pivot table, it is within a performance report. But they can actually be used in creative ways as well. A pivot table can’t be created until after a bulk sheet is created. The important thing is to be sure that you are highlighting any rows and columns that are in the bulk sheet before beginning to create the pivot table. Once you also have the pivot table, the count feature can be used to make sure that the bulk sheet has been created accurately.
Key Takeaways:
- Creating the pivot table should come after you have created your bulk sheet.
- It is important to make sure that the rows and columns in the bulk sheet have been highlighted, before you move on to making the pivot table.
- If you put fields in the values area that aren’t numbers, it will come out as a count, and not a sum.
“In this article, I’ll highlight a use case you might not be familiar with, along with some tips and shortcuts to enhance your pivot table skills.”
Read more: https://searchengineland.com/excel-pivot-table-best-practices-for-search-marketers-389254
