Financial Statements using POWERPIVOT

[BeejSanchez]

Hi guys! I am trying to create financial staements (Income Statement, balance sheet & Cashflow) using power pivot. However, I find it very difficult to do so when my dates are on top of my table. I watched a videoclip on youtube, but didnt specify how to create one in detail. He also has a slicer that can show a specific month and year. I would really appreciate your help guys. Heres an example of my attempt:

1/1/13 1/31/13 2/1/13 3/1/13 etc..
Income
..
..
Total Income:

Expenses
..
.
Total Expenses