topic Calculated Dimension in Pivot with Average function in QlikView https://community.qlik.com/t5/QlikView/Calculated-Dimension-in-Pivot-with-Average-function/m-p/836889#M294317 <HTML><HEAD></HEAD><BODY><P>Guys,</P><P></P><P>Can anyone tell me how can I create a calculated dimension properly?</P><P></P><P>I have a dimension with the name KIND RO.</P><P></P><P>I need to add the d<SPAN style="font-size: 13.3333330154419px;">imesion Processing Period</SPAN> to my pivot table as a calculated dimension. The calculation will be the average hours of processing period according to each Kind RO.</P></BODY></HTML> Wed, 01 Apr 2015 13:49:12 GMT 2015-04-01T13:49:12Z Calculated Dimension in Pivot with Average function https://community.qlik.com/t5/QlikView/Calculated-Dimension-in-Pivot-with-Average-function/m-p/836889#M294317 <HTML><HEAD></HEAD><BODY><P>Guys,</P><P></P><P>Can anyone tell me how can I create a calculated dimension properly?</P><P></P><P>I have a dimension with the name KIND RO.</P><P></P><P>I need to add the d<SPAN style="font-size: 13.3333330154419px;">imesion Processing Period</SPAN> to my pivot table as a calculated dimension. The calculation will be the average hours of processing period according to each Kind RO.</P></BODY></HTML> Wed, 01 Apr 2015 13:49:12 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-in-Pivot-with-Average-function/m-p/836889#M294317 2015-04-01T13:49:12Z Re: Calculated Dimension in Pivot with Average function https://community.qlik.com/t5/QlikView/Calculated-Dimension-in-Pivot-with-Average-function/m-p/836890#M294318 <HTML><HEAD></HEAD><BODY><P>Hi Diana, maybe:</P><P>Aggr(Avg(Hours), Kind RO)</P><P></P><P>Sample data or further expanations will be nice if you want something different.</P></BODY></HTML> Wed, 01 Apr 2015 14:13:51 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-in-Pivot-with-Average-function/m-p/836890#M294318 rubenmarin 2015-04-01T14:13:51Z