Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Distinct Running Sum

PostPosted: 02 Nov 2015 20:02
Post subject: Distinct Running Sum
Reply with quoteEdit/Delete this postDelete this post

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.
Not what you were looking for? View more on this topic or Ask a question