Table Box Filters and Expression HELP!!!

[RedDead]

Hi,

I have a table box where i can have multiple ID's. The multiple ID's are recording where the ID priority has changed. How do i get my table box to show all entries where the ID has had its priority changed?  See example for one ID that has had its Job priority changed.

Thanks

[m_woolf]

Go to Chart Properties|Presentation and hide the field

[RedDead]

Many Thanks for your help on this. I now have the following :-

ID                      PRIORITY

47                     R1

47                     R5

What i would like to do now is concatenate the two priorities to achieve this

ID                      PRIORITY

47                     R1, R5

Ideally i would rather do this within the table and not the script if possible.

What would be your best suggestion on how i could do this?

Thanks

[MarcoWedel]

Hi again,

this expression might work for you:

Concat({$<SK_JOBKEY={"=Count(Distinct JOB_PRIORITY)>1"}>} JOB_PRIORITY, ', ')

hope this helps

regards

Marco