This content has been marked as final. Show 2 replies
Good Morning Community,
I have created a very simple "Order Fill Rate" measurement that will display the average fill rate of orders placed by a customer.
I have also created some unique set analysis that will show the sales for the current fiscal year, then break it down further to the fiscal quarter by combining period 1 thru 3 to represent the 1st Quarter.
What I am looking to do is use a formula that is similar to the Fiscal Quarter 1 field, instead of showing sales number I would like it to display the Order Fill Rate for the fist Fiscal Quarter. It is my hope that I can show a quarter over quarter improvement in performance to our customers and ultimately us this as part of my organizations score card.
The key take away is that I need to display the results by current fiscal year and create the current fiscal quarter (information that does not come from my ERP system directly)