Hello,
Could someone help me, please? I've got a table like
|
| 01.01.2014 | 25 | Thompson Eric |
01.01.2014 | 36 | Grundalf Mark |
| 01.01.2014 | 48 | Stowny Oliver |
| 01.01.2014 | 52 | Clinton Scott |
| 01.02.2014 | 25 | Thompson Eric |
| 01.02.2014 | 36 | Grundalf Mark |
| 01.02.2014 | 48 | Stowny Oliver |
| 01.02.2014 | 52 | Newman Peter |
| 01.03.2014 | 25 | Thompson Eric |
| 01.03.2014 | 36 | Tensley Tom |
| 01.03.2014 | 48 | Stowny Oliver |
| 01.03.2014 | 52 | Newman Peter |
| 01.04.2014 | 25 | Thompson Eric |
| 01.04.2014 | 36 | Tensley Tom |
| 01.04.2014 | 48 | Clarksson Edward |
| 01.04.2014 | 52 | Newman Peter |
From this data I need to get the exsperience of each top, to be able to use if further in charts (the quality of work in the dependent of the exsperience). I've tried to make a temp table, to load and sort by TOP_manager, see if it's the the first entry of top in chart (top_manager<>previos(top_manager)),put the name of first month in a special added field then count months, but it doesn't help// tried to use lookup, peek.... just doesn't work right
I need to get something like
| salary month | Object_ID | TOP_manager | Experience |
| 01.01.2014 | 25 | Thompson Eric | 1 |
| 01.01.2014 | 36 | Grundalf Mark | 1 | |
| 01.01.2014 | 48 | Stowny Oliver | 1 |
| 01.01.2014 | 52 | Clinton Scott | 1 |
| 01.02.2014 | 25 | Thompson Eric | 2 |
| 01.02.2014 | 36 | Grundalf Mark | 2 |
| 01.02.2014 | 48 | Stowny Oliver | 2 |
| 01.02.2014 | 52 | Newman Peter | 1 |
| 01.03.2014 | 25 | Thompson Eric | 3 |
| 01.03.2014 | 36 | Tensley Tom | 1 |
| 01.03.2014 | 48 | Stowny Oliver | 3 |
| 01.03.2014 | 52 | Newman Peter | 2 |
| 01.04.2014 | 25 | Thompson Eric | 4 |
| 01.04.2014 | 36 | Tensley Tom | 2 |
| 01.04.2014 | 48 | Clarksson Edward | 1 |
| 01.04.2014 | 52 | Newman Peter | 3 |
thanks in advance
