BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: BOBJ conference in Paris: Mar 28, PGHBOUG: Apr 4.

Sort on multiple columns


 
Search this topic... | Search Web Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Author Message
abhi234u
Principal Member
Principal Member



Joined: 12 Feb 2007

Posts: 216



PostPosted: Tue Mar 23, 2010 8:33 am 
Post subject: Sort on multiple columns

Hi there,

Will i be able to sort on multiple columns in a report. I have a date and amount columns and the date should be in ascending and the amount should be descending based on the date.

I mean Old records and more dollar amount should be shown first.

Is this scenario possible.

Thanks

Abhi
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19250
Location: Bratislava


flag
PostPosted: Tue Mar 23, 2010 8:40 am 
Post subject: Re: Sort on multiple columns

Hi,

Apply the 1st sort on the date column and the 2nd sort on the amount column.

Or am I missing something? icon_confused.gif

_________________
BO: BI 4.0, 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win, Linux and AIX servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
REB01
Principal Member
Principal Member



Joined: 29 Nov 2004

Posts: 380
Location: Earth.NA.US.KS.OP


flag
PostPosted: Tue Mar 23, 2010 8:41 am 
Post subject: Re: Sort on multiple columns

Open your Properties tab.
Select the column you want to sort first
in your properties tab open the "Sort" section and select the sort
Click in the next column you want to sort and in your properties tab open the "Sort" section and select the sort

Repeat this process for each column you need to sort


EDIT...

Marek, looks like we replied at the same time... Sorry, did not see your reponse until after I sent mine...

_________________
Roland

Put on the whole armor of God
Ephesians 6:11

Visit the band website
Check out our music
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0300 seconds using 17 queries. (SQL 0.0027 Parse 0.0009 Other 0.0265)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo