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.

[Webi 4.x] [Webi 4.x] Getting the Amount of the highest Version of Name


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



Joined: 25 Apr 2018

Posts: 3



PostPosted: Mon Oct 14, 2019 11:23 am 
Post subject: [Webi 4.x] Getting the Amount of the highest Version of Name

Hi all,
could you please suggest how I can achieve the below dataset?
Basically I need to get the row with the higher Version number.

Example data:

Name | Version | Amount
Sem1 | 100 | 20000
Sem1 | 101 | 2400
Dem1 | 321 | 50
Dem1 | 323 | 3000
Fil2 | 200 | 100

I need to get:
Sem1 | 101 | 2400
Dem1 | 323 | 3000
Fil2 | 200 | 100


Many thanks!
Back to top
Ross_BOXI
Senior Member
Senior Member



Joined: 17 Apr 2018

Posts: 62



PostPosted: Tue Oct 15, 2019 4:25 am 
Post subject: Re: [Webi 4.x] Getting the Amount of the highest Version of

something like

Code:
=Rank([Version];([Version]);([Name]))


then filter on 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.0300 seconds using 18 queries. (SQL 0.0030 Parse 0.0008 Other 0.0262)
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