count churn user

[torraninboo]

i want to count fid that include new user, same user ,churn user but i dont know how to count its 

example my data and i want to made report like this

but i dont know how to count its can someone help me

[PrashantSangle]

where you want to do it??

 Qlikview? QlikSense? 

what is logic for New User? Same? Churn??

You have to provide more details for more accurate answer.

[torraninboo]

Oh sry I forgot ,I want to do in qliksense

logic

example month 202201,202202

if fid in monthyear 202202 but not in 202201 = new user

if fid in monthyear 202201 but not in 202202 = churn user

if fid in 202201 and 202202 = same user

[PrashantSangle]

understood. Can you provide some sample data?

[sidhiq91]

@torraninboo  Please provide some sample data?

[torraninboo]

example data and result

[torraninboo]

example data and result

[torraninboo]

example data and result