I have problem to code macro to select multiple item under a particular field in pivot table.
The criteria for the item being used is coming from a table in another sheet (brand)
Brand
PivotTableSheet (pick some sample only):
I have tried using looping mechanism (for i = 0 to ...) to pick all the brand.
But it does not work.
The brand name in the table can change dynamically (as per user needs).
Any idea how to solve this?
The criteria for the item being used is coming from a table in another sheet (brand)
Brand
|
PivotTableSheet (pick some sample only):
| Values | ||||||
| CATEGORY | BRAND | Item Code | Jun-17 | Jul-17 | Aug-17 | Sep-17 |
| PREMIUM | BCL | 010120001000 | 38 | (11) | (22) | 15 |
| PREMIUM | BCL | 010120002000 | 85 | 33 | (6) | 9 |
| PREMIUM | BCL | 010120003000 | 70 | 14 | (8) | 12 |
| PREMIUM | BCL | 010120004000 | 116 | 41 | 7 | 35 |
| PREMIUM | BCL | 010120005000 | 87 | 9 | (12) | 6 |
| PREMIUM | BCL | 010120006000 | 89 | 41 | 14 | 22 |
| PREMIUM | BCL | 010120007000 | 49 | 27 | (3) | 23 |
| PREMIUM | BCL | 010120008000 | 9 | 6 | 5 | 11 |
| PREMIUM | BCL | 010120009000 | 103 | 41 | 3 | 30 |
| PREMIUM | BCL | 010120010000 | 59 | 1 | (17) | 6 |
| PREMIUM | BCL | 010120011000 | 54 | 35 | (4) | 15 |
| PREMIUM | BCL | 010120012000 | 50 | (3) | 3 | (2) |
| PREMIUM | BCL | 010120013000 | 77 | 28 | 2 | 10 |
| PREMIUM | BCL | 010120014000 | 45 | (7) | (4) | 1 |
I have tried using looping mechanism (for i = 0 to ...) to pick all the brand.
But it does not work.
The brand name in the table can change dynamically (as per user needs).
Any idea how to solve this?
