I have some data about customer transactions. Transactions have types so I would like to aggregate on the types of transactions I have. The issue I have is in the Fact table, a customer might belong to multiple regions. so when I have the region in the data, one transaction for a customer, who is in two regions, will appear twice. I need the region so I can use that as a filter. For example, I have the following data:
I want my result to show something like
but I am getting
because transactions 1,2 are being added twice.
Attacked is a workbook with the result. Any help would be greatly appreciated..