rogueakula
New Member
- Joined
- Apr 23, 2018
- Messages
- 19
I am trying to analyze my spending from month to month. To do this, I downloaded my transactions from my bank in a .csv and gave each transaction a generic label (auto, groceries, bills, etc) and separated the transactions based on month. From there I created two pivot tables, one for the month of Sept and one for Oct. Each pivot table contains a column of labels, and then two columns with dollars broken into credit and debit. It looks something like this:
How can I create another pivot table (or any method really) of comparing the same label from one month to another? Bonus points if it shows positive number in black and negative in red. Thanks!
-Josh
transactions.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Sept | ||||
2 | Row Labels | Sum of Credit | Sum of Debit | ||
3 | Auto | $ 459.00 | |||
4 | Groceries | $ 380.00 | |||
5 | Bills | $ 1,300.00 | |||
6 | Deposits | $ 3,000.00 | |||
7 | |||||
8 | Oct | ||||
9 | Row Labels | Sum of Credit | Sum of Debit | ||
10 | Auto | $ 320.00 | |||
11 | Groceries | $ 550.00 | |||
12 | Bills | $ 1,450.00 | |||
13 | Deposits | $ 3,000.00 | |||
Sheet4 |
How can I create another pivot table (or any method really) of comparing the same label from one month to another? Bonus points if it shows positive number in black and negative in red. Thanks!
-Josh