Hi Cor, all!
C.R.Vegelin wrote:
Hi Joerg, All,
I would like to have something like:
Country Type20042005
--
GermanySales13357 19843
Belgium Sales12224 16767
France Sales15443 16602
Un. States Sales
]>
To: "Shawn Green" <[EMAIL PROTECTED]>; "C.R.Vegelin"
<[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, April 25, 2006 2:17 PM
Subject: Re: Top N selections + rest row
Hi Shawn, Cor, all!
Shawn Green wrote:
--- "C.R.Vegelin" <[EMAIL PROTECTED]> wro
in" <[EMAIL PROTECTED]>; "Martijn Tonies"
<[EMAIL PROTECTED]>; ; <[EMAIL PROTECTED]>
Sent: Tuesday, April 25, 2006 1:18 PM
Subject: Re: Top N selections + rest row
--- "C.R.Vegelin" <[EMAIL PROTECTED]> wrote:
Thanks Martijn, Barry,
I was wonder
Hi Shawn, Cor, all!
Shawn Green wrote:
--- "C.R.Vegelin" <[EMAIL PROTECTED]> wrote:
Thanks Martijn, Barry,
I was wondering whether it could be done in a single query.
I want users to decide how many countries they want,
and show world sales on top of report followed by the N countries.
This
> > Thanks Martijn, Barry,
> > I was wondering whether it could be done in a single query.
> > I want users to decide how many countries they want,
> > and show world sales on top of report followed by the N countries.
> > This to enable relative country shares, both for reporting and
> > graphs.
D]>
> To:
> Sent: Tuesday, April 25, 2006 11:06 AM
> Subject: Re: Top N selections + rest row
>
>
> > Hi,
> >
> >>Anybody with smart ideas to get Top-N rows plus the rest row ?
> >>Suppose I have ranked sales values descending for 2005, like:
> &
countries + Rest in a pie graph.
So I need one additional row in the Top-N query.
Regards, Cor
- Original Message -
From: "Martijn Tonies" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, April 25, 2006 11:06 AM
Subject: Re: Top N selections + rest row
Hi,
Anybody with smart id
Hi,
>Anybody with smart ideas to get Top-N rows plus the rest row ?
>Suppose I have ranked sales values descending for 2005, like:
>Select Country, Sum(Sales) AS Sales From myTable
>Where Year=2005 Group By Country
>Order By Sales DESC LIMIT 25;
>
>Then I get Top-25 sales rows, but I also want a
C.R.Vegelin wrote:
Hi All,
Anybody with smart ideas to get Top-N rows plus the rest row ?
Suppose I have ranked sales values descending for 2005, like:
Select Country, Sum(Sales) AS Sales From myTable
Where Year=2005 Group By Country
Order By Sales DESC LIMIT 25;
Then I get Top-25 sales rows,
Hi All,
Anybody with smart ideas to get Top-N rows plus the rest row ?
Suppose I have ranked sales values descending for 2005, like:
Select Country, Sum(Sales) AS Sales From myTable
Where Year=2005 Group By Country
Order By Sales DESC LIMIT 25;
Then I get Top-25 sales rows, but I also want a res
10 matches
Mail list logo
