Sorting on discoverer Pivot Tables
From: simbob <simon.flowers_at_networkrail.co.uk>
Date: 24 Feb 2006 04:01:53 -0800
Message-ID: <1140782513.767208.68010_at_e56g2000cwe.googlegroups.com>
Hi,
Date: 24 Feb 2006 04:01:53 -0800
Message-ID: <1140782513.767208.68010_at_e56g2000cwe.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 Received on Fri Feb 24 2006 - 13:01:53 CET