FormerMember

Report Consolidation multi-units

SUGGESTED
Posted By FormerMember

I'm new to the product, with about a month of experience. I've been designing/modifying existing reports in the financial report designer function. I have two units that individually foot and agree balance wise. Each of these then roll up in total to a consolidated report, for lack of a better term. What I'd LOVE to do, if possible, is to have this consolidated level report have the two units side by side with a total also.

Example would be

                                               Unit A                     Unit B                Consol

Sales                                        100                        250                     350

Right now it only rolls up as one report, one total - as in the 350 above.

I'm not sure if this is doable, but it'd be optimal to have this as opposed to printing out three of every report. Unsure what version we are running, but it appears to be from 2013

Thanks for any/all answers