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