Could you please attach sample data as twbx format.
I've already uploaded it. Thank you for your remind.
I thought I don't get the correct answer on Quarterly and Yearly data. It should be shown monthly average and quarterly average, but not use WINDOW_SUM(SUM([Shipment]),-2,0). Thank you.
monthly R: WINDOW_SUM(SUM([Shipment]),-2,0) /sum two previous shipment to the current shipment.
quarterly R: AVERAGE monthly R. for example: 2014Q1 R=(7976+18098+13154)/3
yearly R: AVERAGE quarterly R. for example: 2014 R= (2014Q1 R+2014Q2 R+2014Q3 R+2014Q4 R)/4