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

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

How to filter & display the highest/lowest value in a ta


 
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
janeb1308
Forum Member
Forum Member



Joined: 02 Dec 2019

Posts: 2



PostPosted: Mon Dec 02, 2019 5:28 am 
Post subject: How to filter & display the highest/lowest value in a ta

I have a table that shows the percentage of room usage over a week by day, eg. Monday 100%, Tuesday 89%, Wednesay 67%... etc. How can I show just the days with the highest usage (eg Monday) and the lowest percentage (eg Wednesday) and filter out the rest of the week values.
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11461
Location: Manchester, UK


flag
PostPosted: Mon Dec 02, 2019 8:29 am 
Post subject: Re: How to filter & display the highest/lowest value in

Have a look at ranking - click on your table then click on the podium smarticon and follow the dialog box that pops up.
_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
janeb1308
Forum Member
Forum Member



Joined: 02 Dec 2019

Posts: 2



PostPosted: Mon Dec 02, 2019 12:29 pm 
Post subject: Re: How to filter & display the highest/lowest value in

I'm using SAP BusinessObjects BI Platform 4.2 Support Pack 4 Patch 3
Version: 14.2.4.2545. I'm sorry but what is podium smarticon?
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11461
Location: Manchester, UK


flag
PostPosted: Tue Dec 03, 2019 5:04 am 
Post subject: Re: How to filter & display the highest/lowest value in

The ranking button with the 123 podium on it.
_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
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.0280 seconds using 17 queries. (SQL 0.0029 Parse 0.0009 Other 0.0243)
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