I have a report with two grids - one with Actual data columns for the periods Jan - the POV selection.
The second grid has forecast data displayed from the Forecast scenario for the rest of the months of the year.
I want to add a column to add the totals of the lines in the two grids to get a YTD column after the Dec column in Grid 2
The lines in the two grids are not identical - i.e. Grid1 may have Total Sales on line 10 whereas Grid2 may have Total Sales on line 13