I will give you my query and see if you can help me. But basically I am just
datasource. Because I have several charts I would have to do that for. For
i know how many times that problem had an instance. I cant group by the
count so I dont know how to get a Top N out of that. My group is
by. The top(N) right now is giving me me the top 5 from alphabetical order.
"Steve Dearman" wrote:
> check the "top 5 values post below, shows how to change the SQL query to
> show only the top five results
>
> QUOTE :::::::::::::
> Just in case you haven't herd of it before it goes:
> SELECT TOP (N) "then the rest of your query" where N is the number of
> results you want to return.
> Make sure your query is sorted by population in decending order so the top
> or first 5 entrys are the highest ones.
>
>
> "Amarnath" <Amarnath@discussions.microsoft.com> wrote in message
> news:0BBC48FC-42DC-46FB-A37A-9AA91129B15D@microsoft.com...
> > Try from sql "top 5" to pick up top 5 cities.
> >
> > Amarnath
> >
> > "Benw" wrote:
> >
> >> I have a chart that returns many values. I just want it to show me the
> >> top 5
> >> values. In other words how can it give me the 5 cities with the biggest
> >> polpulation instead of giving me every city. I want it on a chart.
>
>
> "Benw" <Benw@discussions.microsoft.com> wrote in message
> news:599B4920-A0A0-4057-8400-4CD0D52D6F0B@microsoft.com...
> > Here is my scenario. I have a list of problems occurring monthly. What I
> > want to do is create a graph showing all the months to date and how many
> > times each problem occurred in that month. But there are way to many for
> > a
> > graph. SO now what I want to show is the top 5 problems per month. I
> > need
> > to set the top 5 in the graph and not in the main query because I am using
> > that same data for other graphs.
>
>
