Forum Discussion
arvindarvind24
Helper II
Helper IIAverage on selected Value
Hi, Need to calcuate Average on selected Value. Product Style No Sale Qty Avg Sales Qty Sales Qty/ Avg Sales Qty CD SET 1 30 6.26 4.79 CD SET 2 28 6.26 4.47 CD SET ...
tamerj1
Community Champion
Community ChampionHi arvindarvind24
Please elaborate more on the expected results
arvindarvind24FYI.
Table1 Table1 Table1 Table1 Table2 Based on Product I need the Avg (Result Required) Product Size Style No Colour Sale Qty Avg Sales Qty Product01 S 1 Red 30 12.63 Product01 M 2 Black 28 12.63 Product01 XL 3 Green 14 12.63 Product01 XXL 4 Red 13 12.63 Product01 S 5 Black 11 12.63 Product01 M 6 Green 9 12.63 Product01 XL 7 Red 8 12.63 Product01 XXL 8 Black 7 12.63 Product01 S 9 Green 7 12.63 Product01 M 10 Red 6 12.63 Product01 XL 11 Black 6 12.63 Product02 S 12 Green 5 3.83 Product02 M 13 Red 5 3.83 Product02 XL 14 Black 4 3.83 Product02 XXL 15 Green 4 3.83 Product02 S 16 Red 4 3.83 Product02 M 17 Black 4 3.83 Product02 XL 18 Green 4 3.83 Product02 XXL 19 Red 4 3.83 Product02 S 20 Black 3 3.83 Product02 M 21 Green 3 3.83 Product02 XL 22 Red 3 3.83 Product02 S 23 Black 3 3.83 Product03 XL 24 Green 3 2.54 Product03 XXL 25 Red 3 2.54 Product03 S 26 Black 3 2.54 Product03 M 27 Green 3 2.54 Product03 XL 28 Red 3 2.54 Product03 XXL 29 Black 3 2.54 Product03 S 30 Green 2 2.54 Product03 M 31 Red 2 2.54 Product03 XL 32 Black 2 2.54 Product03 M 33 Green 2 2.54 Product03 M 34 Red 2 2.54 - tamerj1
arvindarvind24
How are table1 and Table2 connected? Are looking for a measure or a calculated column?- arvindarvind24
tamerj1 There are connected through the icode relationship and am looking for measure.