This was the structure of my data previously, but i had changed it to the flattened form as it suited my calculations better.
As you can see, sales keep repeating for every reason in a particular Department and Region. The calculation you have used sums up all the values for Each Department and Region. Ideally it shud be taking only one value.
Eg: Calculated Discout for Rs1 = sum of(RS1)/ sum (sales for all unique Dep-Region combinations)
and not Calculated Discout for Rs1 = sum of(RS1)/ sum (sales)
This is why i needed te flattened data structure.
If you could provide a sample packaged workbook (bogus data if need be). It'll be a lot easier to understand what you're looking for. Thanks,