Create opening and closing balance in Balance Sheet - Report Generator

I am about to build a balance sheet in Report Generator. I would like to create three columns; 

• Opening balance (for period)
• Closing balance (for period)
• Closing balance (last year period)

How do I create this, choosing which column type? If I choose a “Data column” I am able to choose do a period selection but I don’t know if it is the right way to go. And if it is the right way, how do I create the different periods?

Thanks in advance!