Thanks for the reply Albert, however this will not work in my scenario. As i mentioned in my write up above. I cannot sum transactions for a couple reasons. One being that in the industry i am in, the same transaction can appear in any of the POS listed in my exmple, therefore if i summed transactions across POS it would double count transaction amount. Second, because of the reason i just stated i created a POS called Total, so therefore if i summed sales and transactions it would again double count everything.
I need a calculation where i can divide within the POS Dimenstion for example (Meat/Total), then (Seafood/Total) and so on.