Looking to create subtotals based on size scales...
Hi. I am having trouble with creating size scales. Let's say i want to create an order for 120 units. Sizes from xs-xL, based on a scale of 1-1-2-1-1 (xs1, s1, m2, L1, xL1). Totaling 120 units or any given number.
The 120 units would have to be scaled into percents I assume, but not sure what formula.
I would also need to know how to change the scale to lets say 1-2-2-1-1 if need be.
Can you upload a sample workbook? Not sure of the data layout.
Want to show appreciation for the help you received from a member? Give them reps by clicking the bottom left of their post!
Scale Subtotals
1 xs ?
1 s ?
2 m ?
1 l ?
1 xl ?
Total 120
Try something like this (file attached).
PERFECT. Thank You.
You're welcome. If this answers your question please mark your thread as solved using the thread tools (top right of the page, just above your first post).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks