wesley.yau
New Member
- Joined
- Nov 19, 2012
- Messages
- 3
I have two sets of data set up as shown below.
Records of items sold - keeps track of the number of coloured shapes sold.
<TBODY>
</TBODY>
Total number of items in stock
<TBODY>
</TBODY>But total sphere cannot be sold more than 300 and total rectangle cannot be sold more than 350
How do I go about setting up a custom "Percentage Sold" measure like the following?
[Shape] [Colour] [Percentage Sold]
Sphere Red 50% (50 / 100)
Sphere Blue 7.69% (10 / 130)
Sphere White 4.17% (5 / 120)
Total Sphere 21.67% (Instead of 65 / 350, I need 65 / 300)
Same goes for rectangle.
Any help would be appreciated, thanks!
Records of items sold - keeps track of the number of coloured shapes sold.
Shape | Colour | Volumn |
Sphere | Red | 20 |
Sphere | Blue | 10 |
Sphere | White | 5 |
Sphere | Red | 30 |
Rectangle | Blue | 40 |
Rectangle | White | 25 |
Rectangle | Red | 35 |
Rectangle | Blue | 30 |
Rectangle | White | 20 |
<TBODY>
</TBODY>
Total number of items in stock
Shape | Colour | Stock |
Sphere | Red | 100 |
Sphere | Blue | 130 |
Sphere | White | 120 |
Rectangle | Red | 130 |
Rectangle | Blue | 140 |
Rectangle | White | 150 |
<TBODY>
</TBODY>
How do I go about setting up a custom "Percentage Sold" measure like the following?
[Shape] [Colour] [Percentage Sold]
Sphere Red 50% (50 / 100)
Sphere Blue 7.69% (10 / 130)
Sphere White 4.17% (5 / 120)
Total Sphere 21.67% (Instead of 65 / 350, I need 65 / 300)
Same goes for rectangle.
Any help would be appreciated, thanks!