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: No events within the next 45 days.

Max ID for a row


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



Joined: 13 Jun 2019

Posts: 8
Location: Portugal



PostPosted: Mon Jun 17, 2019 2:45 pm 
Post subject: Max ID for a row

Hi my friends,

I need to list the 3 biggest IDs for each ticket. Each ticket lists 3 lines in the report, as I show in the attached print.
I've created a measure variable just like this:
Code:
=Max([ID]) ForEach([Ticket ID])


But the result Is not that I need it.

Can anyone help me.
Thanks.
Back to top
BarkyBaloo
Principal Member
Principal Member



Joined: 04 Jul 2007

Posts: 167



PostPosted: Tue Jun 25, 2019 1:10 am 
Post subject: Re: Max ID for a row

Create a Measure based off the ID and then RANK the top 3 as picture attached and then Break on TICKETID formatting the break to have no Header applied but the table to have the header.
_________________
BarkyBaloo

Your work is going to fill a large part of your life
And the only way to be truly satisfied is to do what you believe is great work.
And the only way to do great work is to love what you do.
If you haven't found it yet, keep looking.
Don't settle.
As with all matters of the heart
You'll know when you find it.
Back to top
n8aktiv
Forum Member
Forum Member



Joined: 28 Dec 2018

Posts: 25


flag
PostPosted: Tue Jun 25, 2019 9:59 am 
Post subject: Re: Max ID for a row

you can create a variable with a ranking()-formula and a second variable with if( …ranking-variable… <=3;1;0)

the second variable can now be used as a table-filter ( ...second variable... = 1 )
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.0327 seconds using 17 queries. (SQL 0.0054 Parse 0.0009 Other 0.0264)
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