Hi,
I have data on the order tab, order number, category code, then by store, a category code could be used multiple times. I then need to calculate the total by each store and category code on the By Type tab. I cant use a pivot as the real table has budget and other numbers feeding that wont...