Below are the ‘Segments’ that we spoke about.
I cant remember what we called them but I will explain again what we would like as a function.
- A Pack Mark (Internal company code) is a collection of Tobacco Grades (bought from a farmer) – these tobacco grades make up the Pack Mark but proportional percentage.
- It would be very useful for us to be able to E.G. select a Pack Mark and it would filter the tobacco grades 1) see on a map where the concentration of these grades are 2) also in a table to see the farmers that sold these grades with the quantity / average price etc
- CAUTION – nearly every farmer might supply these grades so we are trying to see which farmers are producing the most of these grades. I say this for when you illustrate it on the map, maybe bubble size might work and colours per grade…. Don’t know leave it to you and we can see what you guys think.
- I am compelled to say that this is VERY SENSITIVE INFORMATION
Pack Mark Tobacco Grades
M1LT M1L
M1LF
L1L
L2O
L1LC L1LF
L1LF
L2L
M1L
L1OC L1O
L2O
L1LF
L1OFT L1OF
L20
L1M
L1MC L1M
L2M
L1OF
Does this make sense?
If the girls can mock something up this would be fantastic – AND great leverage for ian and I internally if we can get it working