Hi all, is there a way of doing something like the screenshot in NS Reports? I need a balance sheet that is sorted by subsidiary but with most of them grouped with the exception of a couple of them that should have its own column

Yes create a saved search And use formule in result to exclude sub A and Sub B like case when {subsidiary} != sub a or sub b then {amount} End For column C : case when {subsidiary} = sub a then {amount} End

thanks, I’ll take a look. I was hoping to use the standard Balance Sheet Report, sadly I haven’t found a way of doing so