only show the rows which I want, exclude the others in chart page

[sdtfll]

I have a table as below:

load * inline [

ID,name

A,Grant

B,Joey

C,Edmond

D,Antony

];

I need to create a chart page, and only list the ID(A,B) ,exclude (C,D)

the result like this:

ID  name

A  Grant

B   Joey

When I drag the filed ID and name into chart, all IDs are there, how to exclude C and D in chart side ?

(not in script side with where not xx)

[arulsettu · Accepted solution]

maybe like this as dimension in the chart

if(Match(ID,'A','B'),ID)