I would like to find the return rate

[Anonymous]

Product ID	customer	shopname	Purchase date	type
A	A001	ASHOP	20201202	Purchase
A-1	A001	ASHOP	20201203	Returns
B	B001	ASHOP	20201204	Purchase
C	C001	ASHOP	20201206	Purchase
C-1	C001	BSHOP	20201210	Returns
D	A001	BSHOP	20201203	Purchase

If you have data about purchases like the one above

・ Return rate of each purchaser
・ Return rate of each store

I want to ask, but it doesn't work.

return/(return+Purchase)*100=XX%

I want to make a column like this, but it doesn't work

If you could teach me, it'll helps a lot

[Anonymous]

Very great!!

It was helpful!

It's done!

What a new establishment!!

[camargos88 · Accepted solution]

@Anonymous ,

Check the attached file.

[Anonymous]

Dear camargos88

 Thank you for your answers and your helpful.      I can do it.      I learned so much.　　I am very grateful to you.