Business Reporter - balance Current Month, Last Month/Year

Hi,

You can do this by creating a design row where you repeat on account and create three design columns, one for each period. Don't set filter on accounting period in the report header or on sheet but apply filters on each column. Create 2 parameters to select year and period (or one for yearperiod). Then you add function parameters to calculate previous accounting period and last year period. You can use advanced function GET_YEAR_PERIOD_INCR to calculate previous period. You need to add some parameters to calculate year period and convert to string value before you can this function. In a similar way, you can build up a string value for last period from previous year.  Use these parameters to filter accouting periods in relevant columns.