Limit number of entries on a chart

[UHsoccer]

Using Crystal V10.

My group header has many entries and I use the "group sort expert" to sort by size.
Output example
Name1 200
Name2 150
Name3 115
Name4 66
etc

I define "how many to use", say 2, I then suppress printing of name3 and higher.

In the chart I want to display only Name1 and Name2 results. However, they all display and I cannot find a way to restrict what the chart picks up

Help appreciated

 

[lbass]

Use the advanced layout of the chart. Enter {table.name} as the "On change of" field, and while it is selected, choose "topN"->choose "sum of {table.amt}", N = 2, descending order. Uncheck "include others with the name",

That should do it.

-LB