Thanks for the reply Norbert.
This would work fine if I Have 1-2 grouping(filtering) variables.Region in this case.
In real I have many more variables(like 7-8), hence it would be tough to calculate individual sums and cound(s).
So I myself found out a way.
I created calculations for individual totals(using fixed) and then divided in the columns space