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.

Distinct Running Sum


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



Joined: 06 Mar 2015

Posts: 8



PostPosted: Mon Nov 02, 2015 3:02 pm 
Post subject: Distinct Running Sum

I have following table:

Month Id

01/2015 123
01/2015 124


02/2015 123
02/2015 125


I need to count distinct running sum of Id's, For 01/2015 month I have 2 distinct Id's, for 02/2015 I need to get the total distinct Id's of 02/2015 and 01/2015 combined.

Output should be:

Month Count(ID)
01/2015 2
02/2015 3

Any suggestions regarding Count(ID) formula.
Back to top
MBLM
Principal Member
Principal Member



Joined: 31 Jan 2014

Posts: 210


flag
PostPosted: Tue Nov 03, 2015 2:11 am 
Post subject: Re: Distinct Running Sum

http://www.forumtopics.com/busobj/viewtopic.php?t=230998&start=0&postdays=0&postorder=asc&highlight=distinct

Just a short time ago...
Back to top
edberg16
Forum Member
Forum Member



Joined: 06 Mar 2015

Posts: 8



PostPosted: Tue Nov 03, 2015 2:18 pm 
Post subject: Re: Distinct Running Sum

MBLM wrote:
http://www.forumtopics.com/busobj/viewtopic.php?t=230998&start=0&postdays=0&postorder=asc&highlight=distinct

Just a short time ago...


Thank You!!! It worked.
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.0398 seconds using 17 queries. (SQL 0.0154 Parse 0.0008 Other 0.0235)
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