• the user just wants it adding in one group and substracting in another one.

    I think this was what I wasn't understanding. I did have a similar experience once with our technicians and escalations. Some escalations were good, and some not so good, but the tech category had to go under both. I ended up with naming one group Technician(+) and the other Technician(-). Can you do something similar by calling one account Account n (+) and the other Account n (-), with the ETL making the appropriate entries to turn the second one into a negative number?