Hi, I am new to the tool and trying to find a way to get a total % of in stock items by location. My data would look something like this-
Plant Name | SKU Number | SKU Name | Qty EA |
St Louis | 111111 | String | 5 |
St Louis | 111112 | Bow | 4 |
St Louis | 111113 | Arrow | 9 |
St Louis | 111114 | Glove | 0 |
St Louis | 111115 | Strap | 6 |
Chicago | 111111 | String | 2 |
Chicago | 111112 | Bow | 1 |
Chicago | 111113 | Arrow | 6 |
Chicago | 111114 | Glove | 0 |
Chicago | 111115 | Strap | 0 |
Kansas City | 111111 | String | 0 |
Kansas City | 111112 | Bow | 1 |
Kansas City | 111113 | Arrow | 4 |
Kansas City | 111114 | Glove | 4 |
Kansas City | 111115 | Strap | 0 |
And I would like to roll the results in to something like this representing the total percentage of items that have stock. Even if there are only one in stock I would count it as in stock.
St Louis | 80% |
Chicago | 60% |
Kansas City | 60% |
Any help would be appreciated. Thanks
Solved! Go to Solution.
That worked perfectly, thank you so much.
Happy to help : ) @BrianHausman
Cheers and have a nice day!