Skip to Content
avatar image
Former Member

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.
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 03, 2015 at 11:49 AM

    Hi,

    You need to apply formula "count (id) foreach month"

    Add comment
    10|10000 characters needed characters exceeded