I've attached a workbook using your sample data that I think let's calculate the Rate of Shipment all within Tableau. There are a number of steps required to achieve the results though.
1 - Duplicate the data source.
We'll be using one copy of the data source to find the number of orders Ordered and the other copy of the data source to find the number of orders Shipped. I've renamed the data sources to help clarify this
2 - Create a calculated field in each data source called [Date].
In the Order Date data source the calculated field will call [Order Date]. In the Ship Date data source the calculated field will call [Ship Date]. The reason for naming both fields [Date] is that this lets Tableau automatically blend the data sources on this field.
3 - Create running sum calcs.
In the Order Date data source we need a calc using this formula:
In the Ship Date data source we'll need a similar calc with this formula:
(yes, both formulas are exactly the same, the magic will happen when we do the data blending)
4 - Create the Rate of Shipment calc
I created this calc in the Order Date data source that divides the two calcs we created in step 3
5 - Create the view
I did some additional formatting by setting the Fiscal Year start for all the date fields to be in June, as well as just filtering to a single Fiscal Year. I also set the number formatting for our Rate of Shipment calc to be a percentage.
Hope this helps in getting your analysis started!
Rate of Shipment_For Anita.twbx 137.5 KB