How to get avg value in calculated dimension

[#1]

Here is the scenario:

WT % is the dimension. This must be grouped based on taking average across Site, Category, Criteria, Base GMT, Year and Month. So that it will appear as single row. Please suggest. Many thanks. Buvana

				MONTH	Apr	Apr
SITE	Category	Criteria	Base GMT	Wt %	Target	Actual
USG1	Drive 2014 Business Results	Mission Critical Infrastructure	99.80	7.20	99.8	99.84
USG1	Drive 2014 Business Results	Mission Critical Application	99.80	6.40	99.8	99.63
USG1	Drive 2014 Business Results	IT Request: Infrastructure SSR	97.00	4.00	96.6	97.2
USG1	Drive 2014 Business Results	IT Request: Application SSR	96.00	5.60	95	100
USG1	Drive 2014 Business Results	Infrastructure: 95%tile Cycle time	1.00	2.40	1	0.44
USG1	Drive 2014 Business Results	Application: 95%tile Cycle time	2.00	2.40	2	0.84
USG1	Drive 2014 Business Results	Customer Satisfaction: IT Service Desk	4.00	2.40	4	4.39
USG1	Drive 2014 Business Results	Customer Satisfaction: SSR Rating	4.00	2.40	4	4.92
USG1	Drive 2014 Business Results	Number of VOC due to IT	0.00	2.40	0	0
USG1	Drive 2014 Business Results	Cost Savings by actual cost per K Revenue	1.70	1.20	1.55	1.92
USG1	Drive 2014 Business Results	Contribute talent and resources to achieve other site's projects	1.00	2.80	0	2
USG1	Drive 2014 Business Results	Retain top 30% performers	1.00	0.80	0	0
UTL	Drive 2014 Business Results	Mission Critical Infrastructure	99.80	7.00	99.8	100
UTL	Drive 2014 Business Results	Mission Critical Application	99.80	7.00	99.8	100
UTL	Drive 2014 Business Results	IT Request: Infrastructure SSR	97.00	2.50	99.72	100
UTL	Drive 2014 Business Results	IT Request: Application SSR	96.00	6.00	99.53	100
UTL	Drive 2014 Business Results	Infrastructure: 95%tile Cycle time	1.00	2.50	0.27	0.2
UTL	Drive 2014 Business Results	Application: 95%tile Cycle time	2.00	2.50	0.2	0.08
UTL	Drive 2014 Business Results	Customer Satisfaction: IT Service Desk	4.00	2.50	4	4.43
UTL	Drive 2014 Business Results	Customer Satisfaction: SSR Rating	4.00	2.50	4	4.7
UTL	Drive 2014 Business Results	Number of VOC due to IT	0.00	2.50	0	0
UTL	Drive 2014 Business Results	Cost Savings by actual cost per K Revenue	1.70	1.00	0.89	0.974
UTL	Drive 2014 Business Results	Contribute talent and resources to achieve other site's projects	1.00	3.00	0	0
UTL	Drive 2014 Business Results	Retain top 30% performers	1.00	1.00	1	1

[MK_QSL]

Provide sample data please...

[#3]

You can consider this as a sample