Average Sales Per Month of SalesMan in Column

[shri0025]

Hi,

i want to calculate the Average Sale of the particular salesman and enter the average sale in all the rows of Sales Man i am sharing demo the data set .

Date	MonthYear	SalesMan Name	Sales
01-Jan-21	Jan-21	A	8263
02-Jan-21	Jan-21	B	11930
04-Jan-21	Jan-21	C	13123
02-Feb-21	Feb-21	A	19201
07-Feb-21	Feb-21	C	23661
08-Feb-21	Feb-21	B	18552
09-Feb-21	Feb-21	A	24552
01-Mar-21	Mar-21	B	19002
13-Mar-21	Mar-21	C	15662
14-Mar-21	Mar-21	A	23897
15-Mar-21	Mar-21	B	22375

[Mahesh0016 · Accepted solution]

@shri0025 Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[shri0025]

i Need Averegae Sales Per month in Column in Data