Hi All,
I have data set like below,
| Route | ID | Status |
| 6 | 1 | Available |
| 12 | 1 | New Requiremnt |
| 6 | 2 | Available |
| 12 | 2 | New Requiremnt |
| 6 | 3 | Available |
| 12 | 3 | Change Required |
| 18 | 3 | New Requiremnt |
Can you please help me with the expression where in chart it will show the latest record irrespective of selection on Route.
This is default view -
| Route | ID | Status |
| 12 | 28428 | New Requiremnt |
| 12 | 240077 | New Requiremnt |
| 18 | 240127 | New Requiremnt
|
Also if i select route = 6 then it should allow to show below output. If i choose 12 only Route = 12 records should be displayed.
| Route | ID | Status |
| 6 | 28428 | Available |
| 6 | 240077 | Available |
| 6 | 240127 | Available |
Can any one help me in this regard?
