Hi All,
Please help me in this Issue. Your help is most appreciated.
i have fields like CLINENO,CNUMBER,CLINENUMBER , Now i want to group them with expression.
if i select one value in CNUMBER i am getting two values for CLINENUMBER
but i want only 1 CLINENUMBER must be selected in the chart.
see the below example.
| CNUMBER | CLINENUMBER | CLINENO |
| 0809121822069 | 8091218220691 | 1 |
| | 8091218220692 | 2 |
| | | |
| 0809121822075 | 8091218220756 | 6 |
| | 8091218220757 | 7 |
| | 80912182207512 | 12 |
so if i select CNUMBER 0809121822069 , then i want get displayed with this CLINENUMBER 8091218220692
The same here also CNUMBER 0809121822075 and expected is CLINENUMBER 80912182207512.
It should be displayed Based on Max CLINENO.
