Spreadsheet: 39777d1238067463-how-to-look-up-value-in-pivot-table-using-row-and-columns-examplet
Sheet: Receipts

Category | Date | Amount | Description | Budget | [NAME] | Month | Year
Groceries | 2009-03-18 00:00:00 | 45 | Schnucks |  | -45 | 2009-03 | 2009
Fun | 2009-03-22 00:00:00 | 22 |  |  | -22 | 2009-03 | 2009
Groceries | 2009-03-22 00:00:00 | 50 | TJs |  | -50 | 2009-03 | 2009 |  |  | Year | Month | Data
Insurance | 2009-03-25 00:00:00 | 75 | Car payment |  | -75 | 2009-03 | 2009 |  |  | 2009 |  |  |  |  |  |  |  |  | 2009  Amount | 2009  Budget | 2009  [NAME] | Total  Amount | Total  Budget | Total  Variance
Restaurant | 2009-03-25 00:00:00 | 30 |  |  | -30 | 2009-03 | 2009 |  |  | 2009-03 |  |  | 2009-04 |  |  | 2009-05
Fun | 2009-04-02 00:00:00 | 10 | Bought 2 books at B%N |  | -10 | 2009-04 | 2009 |  | Category | Amount | Budget | [NAME] | Amount | Budget | [NAME] | Amount | Budget | [NAME]
Fun | 2009-04-05 00:00:00 | 20 | Went out to bars. |  | -20 | 2009-04 | 2009 |  | 1 income | -5000 | -4000 | 1000 | -5000 | -4000 | 1000 | -5000 | -4000 | 1000 | -15000 | -12000 | 3000 | -15000 | -12000 | 3000
Groceries | 2009-04-06 00:00:00 | 45 |  |  | -45 | 2009-04 | 2009 |  | Fun | 22 | 3000 | 2978 | 30 | 3000 | 2970 | 0 | 3000 | 3000 | 52 | 9000 | 8948 | 52 | 9000 | 8948
Restaurant | 2009-04-22 00:00:00 | 25 | French Bistro |  | -25 | 2009-04 | 2009 |  | Groceries | 95 |  | -95 | 45 |  | -45 |  |  |  | 140 |  | -140 | 140 |  | -140
Restaurant | 2009-04-24 00:00:00 | 25 | Another fancy meal |  | -25 | 2009-04 | 2009 |  | Insurance | 75 |  | -75 |  |  |  |  |  |  | 75 |  | -75 | 75 |  | -75
Rent | 2009-05-01 00:00:00 | 1000 |  |  | -1000 | 2009-05 | 2009 |  | Rent |  |  |  |  |  |  | 1000 |  | -1000 | 1000 |  | -1000 | 1000 |  | -1000
1 income | 2009-03-31 00:00:00 | -5000 |  |  | 5000 | 2009-03 | 2009 |  | Restaurant | 30 |  | -30 | 50 |  | -50 |  |  |  | 80 |  | -80 | 80 |  | -80
1 income | 2009-04-30 00:00:00 | -5000 |  |  | 5000 | 2009-04 | 2009 |  | Grand Total | -4778 | -1000 | 3778 | -4875 | -1000 | 3875 | -4000 | -1000 | 3000 | -13653 | -3000 | 10653 | -13653 | -3000 | 10653
1 income | 2009-05-31 00:00:00 | -5000 |  |  | 5000 | 2009-05 | 2009
1 income | 2009-03-31 00:00:00 | 0 |  | -4000 | -4000 | 2009-03 | 2009
1 income | 2009-04-30 00:00:00 | 0 |  | -4000 | -4000 | 2009-04 | 2009
1 income | 2009-05-31 00:00:00 | 0 |  | -4000 | -4000 | 2009-05 | 2009
Fun | 2009-03-31 00:00:00 | 0 |  | 3000 | 3000 | 2009-03 | 2009 |  |  |  | Year | Data
Fun | 2009-04-30 00:00:00 | 0 |  | 3000 | 3000 | 2009-04 | 2009 |  |  |  | 2009
Fun | 2009-05-31 00:00:00 | 0 |  | 3000 | 3000 | 2009-05 | 2009 |  | Month | Category | Amount | Budget | [NAME]
 |  |  |  |  |  |  |  |  | 2009-03 | 1 income | -5000 | -4000 | 1000
 |  |  |  |  |  |  |  |  |  | Fun | 22 | 3000 | 2978
 |  |  |  |  |  |  |  |  |  | Groceries | 95 |  | -95
 |  |  |  |  |  |  |  |  |  | Insurance | 75 |  | -75
 |  |  |  |  |  |  |  |  |  | Restaurant | 30 |  | -30
 |  |  |  |  |  |  |  |  | 2009-03 Total |  | -4778 | -1000 | 3778
 |  |  |  |  |  |  |  |  | 2009-04 | 1 income | -5000 | -4000 | 1000
 |  |  |  |  |  |  |  |  |  | Fun | 30 | 3000 | 2970
 |  |  |  |  |  |  |  |  |  | Groceries | 45 |  | -45
 |  |  |  |  |  |  |  |  |  | Restaurant | 50 |  | -50
 |  |  |  |  |  |  |  |  | 2009-04 Total |  | -4875 | -1000 | 3875
 |  |  |  |  |  |  |  |  | 2009-05 | 1 income | -5000 | -4000 | 1000
 |  |  |  |  |  |  |  |  |  | Fun | 0 | 3000 | 3000
 |  |  |  |  |  |  |  |  |  | Rent | 1000 |  | -1000
 |  |  |  |  |  |  |  |  | 2009-05 Total |  | -4000 | -1000 | 3000
 |  |  |  |  |  |  |  |  | Grand Total |  | -13653 | -3000 | 10653