Hi, are you able to group results in a header/summ...
# accounting
a
Hi, are you able to group results in a header/summary or formula row in an income statement (or other financial report)? I have grouped sales and purchases by department and I would like to get the gross profit also grouped by department the same way than sales and purchases. I cannot find an option how to group formula or header/summary rows. Is there any ways to do it or any workarounds to get the gross profit grouped by department?
k
Its a lot of work, but you have to create separate financial categories for each department instead of using the group by
Alternatively, you can display columns by department and get the totals and grouping done that way
a
Alright, that's what I expected, requires a lot of work if we wan't to achieve it. But we will think about switching to the column-based layout that doesn't require any additional work. Thank you!