https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Best-Practices/m-p/820846#M200440 <P><a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/150228">@Simon1187</a>,</P> <P>&nbsp;</P> <P>Below how you can do it&nbsp;</P> <P>1- Group by sub and AVG price</P> <P>2- Join to bring the AVG to each line of product&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="messi007_0-1631386523906.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/202130i882D4351C4B94347/image-size/medium?v=v2&amp;px=400" role="button" title="messi007_0-1631386523906.png" alt="messi007_0-1631386523906.png" /></span></P> <P>&nbsp;</P> <P>Attached the workflow.</P> <P>Regards</P> <P>&nbsp;</P> Sat, 11 Sep 2021 18:56:38 GMT messi007 2021-09-11T18:56:38Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Best-Practices/m-p/820815#M200425 <P>Hi there,&nbsp;</P><P>&nbsp;</P><P>I am trying to get the average price for products in sub. Could you please help me with it?&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Simon1187_0-1631368104712.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/202120i1A62D37EA1D0DE68/image-size/medium?v=v2&amp;px=400" role="button" title="Simon1187_0-1631368104712.png" alt="Simon1187_0-1631368104712.png" /></span></P><P>Thanks,&nbsp;</P><P>&nbsp;</P> Sat, 11 Sep 2021 13:49:41 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Best-Practices/m-p/820815#M200425 Simon1187 2021-09-11T13:49:41Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Best-Practices/m-p/820819#M200426 <P>Dear <a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/150228">@Simon1187</a>&nbsp;</P><P>&nbsp;</P><P>like this your mean?</P> Sat, 11 Sep 2021 14:33:34 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Best-Practices/m-p/820819#M200426 Ar13f 2021-09-11T14:33:34Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Best-Practices/m-p/820829#M200431 <P>Hi&nbsp;<a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/150228">@Simon1187</a></P><P>&nbsp;</P><P>it needs a simple change,&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Tyro_abc_0-1631378132531.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/202124iCFB02CE9F996A2F6/image-size/medium?v=v2&amp;px=400" role="button" title="Tyro_abc_0-1631378132531.png" alt="Tyro_abc_0-1631378132531.png" /></span></P><P>Regards</P><P>Tyro</P> Sat, 11 Sep 2021 16:37:30 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Best-Practices/m-p/820829#M200431 Tyro_abc 2021-09-11T16:37:30Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Best-Practices/m-p/820846#M200440 <P><a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/150228">@Simon1187</a>,</P> <P>&nbsp;</P> <P>Below how you can do it&nbsp;</P> <P>1- Group by sub and AVG price</P> <P>2- Join to bring the AVG to each line of product&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="messi007_0-1631386523906.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/202130i882D4351C4B94347/image-size/medium?v=v2&amp;px=400" role="button" title="messi007_0-1631386523906.png" alt="messi007_0-1631386523906.png" /></span></P> <P>&nbsp;</P> <P>Attached the workflow.</P> <P>Regards</P> <P>&nbsp;</P> Sat, 11 Sep 2021 18:56:38 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Best-Practices/m-p/820846#M200440 messi007 2021-09-11T18:56:38Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Best-Practices/m-p/820849#M200441 <P><a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/115913">@messi007</a>&nbsp;</P><P>Thanks</P> Sat, 11 Sep 2021 21:08:10 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Best-Practices/m-p/820849#M200441 Simon1187 2021-09-11T21:08:10Z