Avarage Calculating

[erhan_79]

Hi There ;

İ need to calculateof Avarage Qty of each vendor's in another table as column

İ have a sheet as below 

and i have a table as below 

 i want to create a column on   above table which gives " avarage "  of qty for each vendor as below : 

thanks in advance 

[Greg_Deckler · Accepted solution]

Let's call your tables Table1 and Table2.

Relate Table2 to Table1 on Vendor Name column.

In Table2, create this column:

Column = AVERAGEX(RELATEDTABLE('Table1'),[Qty])

[erhan_79]

 perfect!! @Greg_Deckler  thank you very much!