https://community.qlik.com/t5/QlikView/How-to-create-an-average-aggregated-dimension-in-a-pivot-table/m-p/1786530#M1210104 <P>Thanks so much.&nbsp; Works just as desired!</P> Fri, 26 Feb 2021 10:38:03 GMT BNolan 2021-02-26T10:38:03Z https://community.qlik.com/t5/QlikView/How-to-create-an-average-aggregated-dimension-in-a-pivot-table/m-p/1786509#M1210098 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BNolan_0-1614331864943.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/49941i6C2DED6591BB86F2/image-size/medium?v=v2&amp;px=400" role="button" title="BNolan_0-1614331864943.png" alt="BNolan_0-1614331864943.png" /></span></P><P>Hello, 1st time post...&nbsp; I have a pivot table in Qlikview showing the product costing by month.&nbsp; I need to create a aggr dimension of the average cost.&nbsp;</P><P>I'm able to SUM all of the monthly costing values with</P><P>=num(Aggr( Sum(Costing),Product ),'###.####')</P><P>But I'm struggling with find the number of months to do the division...</P><P>I'm&nbsp; using...</P><P>=Aggr( Count(Costing), Product, MonthYear )</P><P>Any ideas?&nbsp; I'm baffled!</P><P>Thanks,</P><P>Bernard</P><P>&nbsp;</P> Fri, 26 Feb 2021 09:39:01 GMT https://community.qlik.com/t5/QlikView/How-to-create-an-average-aggregated-dimension-in-a-pivot-table/m-p/1786509#M1210098 BNolan 2021-02-26T09:39:01Z https://community.qlik.com/t5/QlikView/How-to-create-an-average-aggregated-dimension-in-a-pivot-table/m-p/1786528#M1210102 <P>HI&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/93337">@BNolan</a>&nbsp;</P><P>For find the division of the month, try like below</P><P><SPAN>=Aggr( Count(Distinct MonthYear), Product)</SPAN></P> Fri, 26 Feb 2021 10:32:46 GMT https://community.qlik.com/t5/QlikView/How-to-create-an-average-aggregated-dimension-in-a-pivot-table/m-p/1786528#M1210102 MayilVahanan 2021-02-26T10:32:46Z https://community.qlik.com/t5/QlikView/How-to-create-an-average-aggregated-dimension-in-a-pivot-table/m-p/1786530#M1210104 <P>Thanks so much.&nbsp; Works just as desired!</P> Fri, 26 Feb 2021 10:38:03 GMT https://community.qlik.com/t5/QlikView/How-to-create-an-average-aggregated-dimension-in-a-pivot-table/m-p/1786530#M1210104 BNolan 2021-02-26T10:38:03Z