Re: Sorting on discoverer Pivot Tables
Date: Thu, 2 Mar 2006 11:57:07 +0100
Message-ID: <du6j55$44b$1_at_ss405.t-com.hr>
"simbob" <simon.flowers_at_networkrail.co.uk> wrote in message
news:1140782530.817740.315740_at_i39g2000cwa.googlegroups.com
> Hi,
>
> I am a bit of a beginner on Oracle Discoverer and need to sort with by
> a field (months, years)but not actually show the information on the
> sheet/graph.
>
> For example: I want to show Dec Jan and Feb in that order, but it
> sorts by Dec Feb Jan!!
> When I put in the month MM(12, 01,02) it sorts fine but it also shows
> that data and it looks quite crap! 2005, 01 JAN 15 for example. I
> just want it to say 2005 JAN 15 or even better 15 JAN 2005!!!
>
> Thanks
Calculation item or any other field doesn't have to be displayed ("Hidden" option), and can be used for sorting in the same time. But what you really need is an item class with Alternative Sort attribute, created with Discoverer Administrator. Received on Thu Mar 02 2006 - 11:57:07 CET