Not sure if I fully got it, have you actually JOINed the two tables? And you want to use the above expression in a table object with what dimensions?
I assume you may need something along these lines:
=SUM(AGGR ( SUM([On Hand Qty]), [Brand], [Item]))
but maybe I just don't understand your setting. A small sample app might help, too.
Thanks for the quick response. Sorry, I mispoke. They are not joined, not sure of the proper term, but they are distinct tables keyed on the fields I mentioned. I did try your suggestion though and I get the missing brands but now the figures are way over. I think it is duplicating data. So, if the item on hand for a company is 10 and the item is in 10 chains the on hand is showing as 100.
If I can't get this figured out I will post a sample, but there is so much in this document I fear I will spend hours just doing that, which may be what is necessary in the end. Thanks again!