Both the tools are used for different purposes altogether. The key difference is that a Pivot tables is used to summarise the data and group things to present a report and can also quickly compare the subsets...