CODEWITHSUNDEEP
google-sheetspivot-tablereport
Igor K
Igor K

Reputation: 53

Google sheets - create a pivot table from two different sheets (income, expenses)

I want to create a pivot table, or a report from two different G.Sheet sheets. One is income sheet, and other is expenses. On both sheets there is a same category with the same data validation (name of the project).

What I am trying to get is a pivot table, or some kind of report that would calculate the difference between incomes and expenses for each project, like:

The result should be this

The link to the sample document is here

Thank you all!

Upvotes: 0

Views: 121

Answers (2)

rockinfreakshow
rockinfreakshow

Reputation: 29904

Here's one formula-based approach which you may test out:

=let(Σ;unique(tocol({Expenses!G2:G;Income!F2:F};1));
     sort(hstack(Σ;index(sumif(Income!F:F;Σ;Income!D:D)-sumif(Expenses!G:G;Σ;Expenses!E:E)));2;))

enter image description here

Upvotes: 1

Buddhiraj Sahu
Buddhiraj Sahu

Reputation: 21

Hii Follow this to generate the pivot of your choice :

two things you need to do

  1. Keep the project column in row of pivot table and
  2. keep the amount at the value and also make sure the function being used is SUM

Attached a screenshot of the configuration below :

enter image description here

Upvotes: 0

Related Questions