When creating a pivot table, you can use data from the same document or data from an external file as the source.
When preparing the source data, it is recommended to take into account the following requirements:
•The table columns / top cells of the range with the source data must have headers.
•It is recommended to use data in one format within one column of the table.
You can create a pivot table on a new sheet or on the sheet you are working on.