cancel
Showing results for 
Search instead for 
Did you mean: 

Distinct Running Sum

Former Member
0 Kudos
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.

Accepted Solutions (0)

Answers (1)

Answers (1)

saurabh_raheja
Participant
0 Kudos

Hi,

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