The table above shows a two-dimensional pivot table with the rows being vendor names and the items as columns. To add any field to any area, just drag and drop it there as shown below: Selected Fields:
![advanced pivot tables in excel 2016 advanced pivot tables in excel 2016](https://static.javatpoint.com/ms/excel/images/how-to-create-a-pivot-table-in-excel.png)
![advanced pivot tables in excel 2016 advanced pivot tables in excel 2016](https://www.howtogeek.com/wp-content/uploads/2009/11/1piv.png)
The columns contain the same type of data i.e the IDs, dates, names, etc respectively. There are no empty rows or columns in this table and the first row has unique names for every column i.e Order ID, Date, Name, etc.
![advanced pivot tables in excel 2016 advanced pivot tables in excel 2016](https://www.xelplus.com/wp-content/uploads/2021/03/Advanced-Pivot-Tables-01.png)
The summary can be based on any field such as sales, averages, sums, etc that the pivot table represents in a simple and intelligent manner.