Our bookstore has two separate documents in Google Sheets (one containing purchase data and one with sales data). Each document contains a sheet with a pivot table that sums up total purchases/sales by book category. I wanted to create a third sheet that shows the difference between the two (i.e. profit margin by category).

I was able to find the IMPORTRANGE function that can pull the data range from one sheet to another, but I cannot figure out how to generate a new pivot table showing the difference between the two tables.

Can someone explain to me how to do this? (Assume for the sake of simplicity that the two documents are named "A" and "B" and that the data is in a sheet called "Sheet 1" in each of them, each with two columns "Section" and "Total").

- Serverfault Help
- Superuser Help
- Ubuntu Help
- Webapps Help
- Webmasters Help
- Programmers Help
- Dba Help
- Drupal Help
- Wordpress Help
- Magento Help
- Joomla Help
- Android Help
- Apple Help
- Game Help
- Gaming Help
- Blender Help
- Ux Help
- Cooking Help
- Photo Help
- Stats Help
- Math Help
- Diy Help
- Gis Help
- Tex Help
- Meta Help
- Electronics Help
- Stackoverflow Help
- Bitcoin Help
- Ethereum Help