Suppose you are working in spreadsheet and you want to display two different pivot table in the same spread sheet. Usually if you create pivot table without choosing the result sheet, it will create a new sheet. So let us check how we can display the result in our desired sheet so that we can show different pivot tables in the same sheet.