Excel powerpivot: average customers by month with certain total sales

[jowrwn]

Hi,

Please help to write code in Excel 2016 Powerpivot.

Thank you.
Johanes

Item

Date

Cust No

Amount

A

01-Jan​

A1

350​

B

02-Jan​

A1

200​

Jan

2 customers with total sales >= $700 (A1 and B1)

C

03-Jan​

A1

300​

1 customer with total sales < 700 (C1)

A

04-Jan​

B1

400​

B

05-Jan​

B1

200​

Feb

1 customer with total sales >= $700 (C1)

C

06-Jan​

B1

150​

3 customers with total sales < $700 (A1, B1 and D)

A

07-Jan​

C1

100​

B

08-Jan​

C1

200​

A

01-Feb​

A1

50​

Result

Average customer with sales >= $700 during Jan till Feb is (2+1)/2 = 1,5

B

01-Feb​

A1

50​

Average customer with sales < $700 during Jan till Feb is (1+3)/2 = 2

C

01-Feb​

A1

50​

A

01-Feb​

B1

50​

B

01-Feb​

B1

50​

C

01-Feb​

B1

50​

A

01-Feb​

C1

500​

B

01-Feb​

C1

200​

A

01-Feb​

D

10​

B

01-Feb​

D

20​

A

01-Feb​

D

30​

B

01-Feb​

D

40​