Hi Guys,
I am currently working on a Benchmarking tool which will be used to compare a single Country (Benchmark Country - BMC) to a selected Pool of Countries (PoolC) in several KPIs. I have a table with the following structure:
| Country | KPI | System | Value |
|---|
| Portugal | KPI 1 | A | 10 |
| Italy | KPI 1 | D | 15 |
| Italy | KPI 3 | B | 20 |
| USA | KPI 2 | C | 35 |
| ... | ... | ... | ... |
|---|
To illustrate which Systems may need improvement I finally want to end up with a table in the following form for each KPI:
KPI N:
| System | BMC | Pool Mean | Delta: BMC - Pool Mean |
|---|
| A | 10 | 15 | -5 |
| B | 20 | 15 | 5 |
| C | 30 | 10 | 20 |
Since the selection of BMC as well as PoolC is supposed to be dynamic I was thinking about creating an additional column (lets call it 'category' for this example) in the first table that changes according to a fieldselection in two Country listboxes.
One sets this category column to 'BMC' for all the entries with the same Country name as Selectionbox number 1. The other one sets all the entries in this category column to 'P' for PoolC for all the Countries that are specified in Selectionbox number 2.
My question now is:
"How can I use selections in listboxes to update this category column?"
I am really stuck here so any help is greatly appreciated!
Thank you!
