topic How to get avg value in calculated dimension in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-get-avg-value-in-calculated-dimension/m-p/745192#M1192 <HTML><HEAD></HEAD><BODY><P><BR />Here is the scenario:</P><P></P><P>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 </P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 596pt; border-collapse: collapse;" width="792"><TBODY><TR style="height: 12.75pt;"><TD class="xl65" height="17" style="border-width: 0.5pt 1pt 1pt 0.5pt; border-style: solid; border-color: black; width: 74pt; height: 12.75pt; background-color: silver;" width="98"><SPAN style="font-family: Tahoma;"> </SPAN></TD><TD class="xl65" style="border-width: 0.5pt 1pt 1pt 0.5pt; border-style: solid; border-color: black; width: 74pt; background-color: silver;" width="98"><SPAN style="font-family: Tahoma;"> </SPAN></TD><TD class="xl65" style="border-width: 0.5pt 1pt 1pt 0.5pt; border-style: solid; border-color: black; width: 248pt; background-color: silver;" width="330"><SPAN style="font-family: Tahoma;"> </SPAN></TD><TD class="xl65" style="border-width: 0.5pt 1pt 1pt 0.5pt; border-style: solid; border-color: black; width: 65pt; background-color: silver;" width="86"><SPAN style="font-family: Tahoma;"> </SPAN></TD><TD class="xl66" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 57pt; background-color: #e1e1e1;" width="76"><SPAN style="font-family: Tahoma;">MONTH</SPAN></TD><TD class="xl67" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 39pt; background-color: white;" width="52"><SPAN style="font-family: Tahoma;">Apr</SPAN></TD><TD class="xl67" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 39pt; background-color: white;" width="52"><SPAN style="font-family: Tahoma;">Apr</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl68" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: #e1e1e1;"><SPAN style="font-family: Tahoma;">SITE</SPAN></TD><TD class="xl68" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: #e1e1e1;"><SPAN style="font-family: Tahoma;">Category</SPAN></TD><TD class="xl68" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: #e1e1e1;"><SPAN style="font-family: Tahoma;">Criteria</SPAN></TD><TD class="xl68" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: #e1e1e1;"><SPAN style="font-family: Tahoma;">Base GMT</SPAN></TD><TD class="xl69" style="border-width: 1pt 1pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; background-color: #e1e1e1;"><SPAN style="font-family: Tahoma;">Wt %</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Target</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Actual</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">USG1</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Mission Critical Infrastructure</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">99.80</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">7.20</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">99.8</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">99.84</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">USG1</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Mission Critical Application</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">99.80</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">6.40</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">99.8</SPAN></TD><TD align="right" class="xl72" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: yellow;"><SPAN style="font-family: Tahoma;">99.63</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">USG1</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">IT Request: Infrastructure SSR</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">97.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">4.00</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">96.6</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">97.2</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">USG1</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">IT Request: Application SSR</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">96.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">5.60</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">95</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">100</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">USG1</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Infrastructure: 95%tile Cycle time</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">1.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.40</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">1</SPAN></TD><TD align="right" class="xl73" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: maroon;"><SPAN style="font-family: Tahoma;">0.44</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">USG1</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Application: 95%tile Cycle time</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.40</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">2</SPAN></TD><TD align="right" class="xl73" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: maroon;"><SPAN style="font-family: Tahoma;">0.84</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">USG1</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="color: #000000; font-family: Tahoma;">Customer Satisfaction: IT Service Desk</SPAN></TD> <TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="color: #000000; font-family: Tahoma;">4.00</SPAN></TD> <TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="color: #000000; font-family: Tahoma;">2.40</SPAN></TD> <TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">4</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">4.39</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">USG1</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Customer Satisfaction: SSR Rating</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">4.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.40</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">4</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">4.92</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">USG1</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Number of VOC due to IT</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">0.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.40</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">0</SPAN></TD><TD align="right" class="xl74" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">0</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">USG1</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Cost Savings by actual cost per K Revenue</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">1.70</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">1.20</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">1.55</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">1.92</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">USG1</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Contribute talent and resources to achieve other site's projects</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">1.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.80</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">0</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">2</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">USG1</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Retain top 30% performers</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">1.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">0.80</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">0</SPAN></TD><TD align="right" class="xl74" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">0</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">UTL</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Mission Critical Infrastructure</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">99.80</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">7.00</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">99.8</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">100</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">UTL</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Mission Critical Application</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">99.80</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">7.00</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">99.8</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">100</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">UTL</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">IT Request: Infrastructure SSR</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">97.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.50</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">99.72</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">100</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">UTL</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">IT Request: Application SSR</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">96.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">6.00</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">99.53</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">100</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">UTL</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Infrastructure: 95%tile Cycle time</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">1.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.50</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">0.27</SPAN></TD><TD align="right" class="xl73" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: maroon;"><SPAN style="font-family: Tahoma;">0.2</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">UTL</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Application: 95%tile Cycle time</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.50</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">0.2</SPAN></TD><TD align="right" class="xl73" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: maroon;"><SPAN style="font-family: Tahoma;">0.08</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">UTL</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Customer Satisfaction: IT Service Desk</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">4.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.50</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">4</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">4.43</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">UTL</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Customer Satisfaction: SSR Rating</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">4.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.50</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">4</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">4.7</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">UTL</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Number of VOC due to IT</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">0.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.50</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">0</SPAN></TD><TD align="right" class="xl74" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">0</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">UTL</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Cost Savings by actual cost per K Revenue</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">1.70</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">1.00</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">0.89</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">0.974</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">UTL</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Contribute talent and resources to achieve other site's projects</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">1.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">3.00</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">0</SPAN></TD><TD align="right" class="xl74" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">0</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">UTL</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Retain top 30% performers</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">1.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">1.00</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">1</SPAN></TD><TD align="right" class="xl73" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: maroon;"><SPAN style="font-family: Tahoma;">1</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Tue, 16 Dec 2014 11:53:04 GMT 2014-12-16T11:53:04Z How to get avg value in calculated dimension https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-get-avg-value-in-calculated-dimension/m-p/745192#M1192 <HTML><HEAD></HEAD><BODY><P><BR />Here is the scenario:</P><P></P><P>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 </P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 596pt; border-collapse: collapse;" width="792"><TBODY><TR style="height: 12.75pt;"><TD class="xl65" height="17" style="border-width: 0.5pt 1pt 1pt 0.5pt; border-style: solid; border-color: black; width: 74pt; height: 12.75pt; background-color: silver;" width="98"><SPAN style="font-family: Tahoma;"> </SPAN></TD><TD class="xl65" style="border-width: 0.5pt 1pt 1pt 0.5pt; border-style: solid; border-color: black; width: 74pt; background-color: silver;" width="98"><SPAN style="font-family: Tahoma;"> </SPAN></TD><TD class="xl65" style="border-width: 0.5pt 1pt 1pt 0.5pt; border-style: solid; border-color: black; width: 248pt; background-color: silver;" width="330"><SPAN style="font-family: Tahoma;"> </SPAN></TD><TD class="xl65" style="border-width: 0.5pt 1pt 1pt 0.5pt; border-style: solid; border-color: black; width: 65pt; background-color: silver;" width="86"><SPAN style="font-family: Tahoma;"> </SPAN></TD><TD class="xl66" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 57pt; background-color: #e1e1e1;" width="76"><SPAN style="font-family: Tahoma;">MONTH</SPAN></TD><TD class="xl67" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 39pt; background-color: white;" width="52"><SPAN style="font-family: Tahoma;">Apr</SPAN></TD><TD class="xl67" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 39pt; background-color: white;" width="52"><SPAN style="font-family: Tahoma;">Apr</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl68" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: #e1e1e1;"><SPAN style="font-family: Tahoma;">SITE</SPAN></TD><TD class="xl68" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: #e1e1e1;"><SPAN style="font-family: Tahoma;">Category</SPAN></TD><TD class="xl68" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: #e1e1e1;"><SPAN style="font-family: Tahoma;">Criteria</SPAN></TD><TD class="xl68" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: #e1e1e1;"><SPAN style="font-family: Tahoma;">Base GMT</SPAN></TD><TD class="xl69" style="border-width: 1pt 1pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; background-color: #e1e1e1;"><SPAN style="font-family: Tahoma;">Wt %</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Target</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Actual</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">USG1</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Mission Critical Infrastructure</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">99.80</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">7.20</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">99.8</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">99.84</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">USG1</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Mission Critical Application</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">99.80</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">6.40</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">99.8</SPAN></TD><TD align="right" class="xl72" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: yellow;"><SPAN style="font-family: Tahoma;">99.63</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">USG1</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">IT Request: Infrastructure SSR</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">97.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">4.00</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">96.6</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">97.2</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">USG1</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">IT Request: Application SSR</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">96.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">5.60</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">95</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">100</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">USG1</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Infrastructure: 95%tile Cycle time</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">1.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.40</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">1</SPAN></TD><TD align="right" class="xl73" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: maroon;"><SPAN style="font-family: Tahoma;">0.44</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">USG1</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Application: 95%tile Cycle time</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.40</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">2</SPAN></TD><TD align="right" class="xl73" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: maroon;"><SPAN style="font-family: Tahoma;">0.84</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">USG1</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="color: #000000; font-family: Tahoma;">Customer Satisfaction: IT Service Desk</SPAN></TD> <TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="color: #000000; font-family: Tahoma;">4.00</SPAN></TD> <TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="color: #000000; font-family: Tahoma;">2.40</SPAN></TD> <TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">4</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">4.39</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">USG1</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Customer Satisfaction: SSR Rating</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">4.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.40</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">4</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">4.92</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">USG1</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Number of VOC due to IT</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">0.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.40</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">0</SPAN></TD><TD align="right" class="xl74" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">0</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">USG1</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Cost Savings by actual cost per K Revenue</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">1.70</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">1.20</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">1.55</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">1.92</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">USG1</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Contribute talent and resources to achieve other site's projects</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">1.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.80</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">0</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">2</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">USG1</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Retain top 30% performers</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">1.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">0.80</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">0</SPAN></TD><TD align="right" class="xl74" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">0</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">UTL</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Mission Critical Infrastructure</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">99.80</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">7.00</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">99.8</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">100</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">UTL</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Mission Critical Application</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">99.80</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">7.00</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">99.8</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">100</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">UTL</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">IT Request: Infrastructure SSR</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">97.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.50</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">99.72</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">100</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">UTL</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">IT Request: Application SSR</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">96.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">6.00</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">99.53</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">100</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">UTL</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Infrastructure: 95%tile Cycle time</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">1.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.50</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">0.27</SPAN></TD><TD align="right" class="xl73" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: maroon;"><SPAN style="font-family: Tahoma;">0.2</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">UTL</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Application: 95%tile Cycle time</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.50</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">0.2</SPAN></TD><TD align="right" class="xl73" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: maroon;"><SPAN style="font-family: Tahoma;">0.08</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">UTL</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Customer Satisfaction: IT Service Desk</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">4.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.50</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">4</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">4.43</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">UTL</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Customer Satisfaction: SSR Rating</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">4.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.50</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">4</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">4.7</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">UTL</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Number of VOC due to IT</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">0.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">2.50</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">0</SPAN></TD><TD align="right" class="xl74" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">0</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">UTL</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Cost Savings by actual cost per K Revenue</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">1.70</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">1.00</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">0.89</SPAN></TD><TD align="right" class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: green;"><SPAN style="font-family: Tahoma;">0.974</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">UTL</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Contribute talent and resources to achieve other site's projects</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">1.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">3.00</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">0</SPAN></TD><TD align="right" class="xl74" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">0</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma;">UTL</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Drive 2014 Business Results</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">Retain top 30% performers</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">1.00</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: white;"><SPAN style="font-family: Tahoma;">1.00</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: navy black black navy; background-color: white;"><SPAN style="color: #000080; font-family: Tahoma;">1</SPAN></TD><TD align="right" class="xl73" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: maroon;"><SPAN style="font-family: Tahoma;">1</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Tue, 16 Dec 2014 11:53:04 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-get-avg-value-in-calculated-dimension/m-p/745192#M1192 2014-12-16T11:53:04Z Re: How to get avg value in calculated dimension https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-get-avg-value-in-calculated-dimension/m-p/745193#M1193 <HTML><HEAD></HEAD><BODY><P>Provide sample data please...</P></BODY></HTML> Tue, 16 Dec 2014 11:57:44 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-get-avg-value-in-calculated-dimension/m-p/745193#M1193 MK_QSL 2014-12-16T11:57:44Z Re: How to get avg value in calculated dimension https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-get-avg-value-in-calculated-dimension/m-p/745194#M1194 <HTML><HEAD></HEAD><BODY><P>You can consider this as a sample</P></BODY></HTML> Tue, 16 Dec 2014 12:55:06 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-get-avg-value-in-calculated-dimension/m-p/745194#M1194 2014-12-16T12:55:06Z