Hi Qlikians,
Wishing you a merry Christmas and a happy new year filled with health, wealth, and joy.
Please help me to find the data.
Attached 3 excel file
1. Raw file- Here what i am getting the data
2. Master- Created master against the facility to updated facility & in the same file I have correct warehouse tagging against the pin code,
3. Calculation & Output- In this file I VLOOKUP Updated Facility & Correct Warehouse then Pivot has been done against the order id how many orders has been gone to correct warehouse or wrong warehouse and the percentage of it.
Note- As we have so much of products so the order id will be repeated as if we don't have the products in the same warehouse so the order id be allocated to different different warehouse.
Please help me to close it.
Thanks in Advance 🙂
