Combine data from two grid to one
Hi All,
I am new to Hyperion Financial Reporting. I nned some help with a report that I am trying to generate. Following are the details :
Grid 1 : ( Built from Essbase 11.1.1.3)
Account Type, Amount
101, 123,000
102, 145,650
103, 100
Grid 2: (Built from HFM 11.1.1.3)
Account Type, Amount
101, 123,000
102, 145,000
104, 200
Above two grids are ready but i want to achieve the following :
Grid 3 (Main)
Account Type, Grid 1 Amount, Grid 2 Amount, Difference
101, 123,000 , 123,000, *0*
102, 145,650 , 145,000, *650 *
*103*, 100 , , *100*
*104,* , 200 , *200*
Also if we can somehow achieve this in grid 1 or 2 , that is also fine. Also if needed we can hide Grid 1 and 2. Please advice if this is do able or not.
Any help/suggestion is appreciated.
Thanks.