Column Calculation
In a FSG report which includes 4 columns (Company1, Company2, Company3 & Group), the goup column has to include figures as belaw
Sales (Raw1) Addition of Company 2 & 3
Cost of sales (Raw 2) Only company 1
Gross Profit (Raw 3) Addition of Company 2 & 3 - Company 1
Expenses (Raw 4) Addition of all 3 columns
(Natural accounts have been assigned to raw set & company values have been assigned to column set)
Is it possible to set up the group column as the above requirement?
Thank you