Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Graph

Status
Not open for further replies.

pungigi

Programmer
Oct 29, 2003
115
US
I have a report that has a crosstab that lists count of trips by vendors as follows:
A B E C P Total

Name 5 6 7 10 12 38

Is there a way to graph by vendor based on TopN & sorted most to least???
 
pungigi,

YES - when you are in the Chart Expert - go to the second tab called Data - and choose the Advanced button on the left hand side - notice the Order and TopN buttons beneath the "On the Change of" dropdown box - of course you must choose the fields you are charting on before they become live!

This one got me too - they are well hidden!

Cheers,

paulmarr
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top