L
Lobb[cz]
Hi everybody,
First of all please excuse my English. I have problem I cannot solve.
Have Access table with several columns - Item #, Category #, "Percast"
where "Percast" is share of all sales in Category. Here is an example:
Item Category Percast
1 100 26
2 100 18
3 100 7
4 100 3
5 200 11
6 200 6
7 200 5
8 200 2
9 300 16
10 300 12
11 300 7
12 300 2
Item Nr. 1 have 26 % share in Category 100.
...
Item Nr. 12 have 2% share in Category 300.
I need to select items, that have (together) at least 20 % share in
Category. And I need to find a way how to select these items.
In category 100 it should select only item Nr. 1 (because this item
have share over 20 %).
In category 200 it should select items Nr. 5, 6, 7 (Percast 11+6+5 >
20).
In category 300 it should select items Nr. 9 and 10 (Percast 16+12 >
20).
Not easy, I know Hope you understand what I need and hope that
anybody in here will help me to find the right solution.
Thanx.
First of all please excuse my English. I have problem I cannot solve.
Have Access table with several columns - Item #, Category #, "Percast"
where "Percast" is share of all sales in Category. Here is an example:
Item Category Percast
1 100 26
2 100 18
3 100 7
4 100 3
5 200 11
6 200 6
7 200 5
8 200 2
9 300 16
10 300 12
11 300 7
12 300 2
Item Nr. 1 have 26 % share in Category 100.
...
Item Nr. 12 have 2% share in Category 300.
I need to select items, that have (together) at least 20 % share in
Category. And I need to find a way how to select these items.
In category 100 it should select only item Nr. 1 (because this item
have share over 20 %).
In category 200 it should select items Nr. 5, 6, 7 (Percast 11+6+5 >
20).
In category 300 it should select items Nr. 9 and 10 (Percast 16+12 >
20).
Not easy, I know Hope you understand what I need and hope that
anybody in here will help me to find the right solution.
Thanx.