Here the data set that i have has competitor I and store number as the primary keys.
I want to calculate sales figures at different levels. say if i want to find out sum of sales of last year for all the stores which has competitor as competitor 1, so in this case store number 1 has 2 stores of competitor 1 near it thus the sales figures will be considered twice for aggregation.
but i want that one store should be considered only once even if it has more than one competitor store of the same corporate owner. here the issue that is coming up is that it is considering the store number 1 twice.