How to get cumulative unique count ?

[#1]

Hi Team ,

I have 4 years of data and want to show only last 2 years of data,by calculating cumulative unique count of users.

For a month I want to get unique count of name from beginning upto the month(include the month)

For your reference please find the sample input and required output

Input

=========

Output

[MK_QSL]

Request you to provide sample data either as Inline table in Application or In Excel file which would be much easier to work and give answer...Thanks

[#3]

Thanks for your reply..

Please find the attached qvw file.

The output required is Cumulative Unique Counts and Unique Count(which is direct)

Thanks in Advance

Sreehari

[MK_QSL]

Like this?

[#5]

Hi Manish,

Thanks for your reply.

But for me I don't have any column with Total Value or cumulative .Just have 3 Columns Year,Month, Login.

I want to Calculate unique cumulative login Count i.e from beginning to current month (includes Current month).how much is unique Login Count and also count of unique logins for current month.

Thanks in Advance

Sreehari Satheesan

[MK_QSL]

Check my document and script..please