The reason that it's not calculating correctly is that you don't have a unique id for the sale; I added a concatenated field Month + Outlet and it calculated properly. Also the trimmed mean you have on the monthly view is not calculating properly, it should go down when you lower the upper threshold (eliminating high range from median calculation). Why it's doing that is beyond me right now.