This discussion is archived
0 Replies Latest reply: Aug 22, 2013 1:05 PM by 9aaa15fb-9310-4c5e-8576-27384d0e2994 RSS

Adding accounts from two grids in a report

9aaa15fb-9310-4c5e-8576-27384d0e2994 Newbie
Currently Being Moderated

Hi,

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

 

Thanks


Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points