COUNT IFS

[CDF234557]

Hi -- I am relatively new to Alteryx and trying to figure out how to replicate a CountIf in Alteryx... 

My current table is as approx as follows: 

Note (if helpful) though I don't think should change the formula)

W - Date

X - V_W String

Y - V_W String 

Z - Integer

*** (target outcome) - is a count of the Zs total present for XY combinations but I don't want to drop the W value becaus

W	X	Y	Z
1	A	C	50
1	A	D	50
2	A	C	50
2	A	D	50
3	A	C	50
3	A	D	50
4	A	C	50
4	A	D	50

I am trying to get the following output: 

W	X	Y	Z	***
1	A	C	50	4
1	A	D	50	4
2	A	C	50	4
2	A	D	50	4
3	A	C	50	4
3	A	D	50	4
4	A	C	50	4
4	A	D	50	4

Any advice? My summarize function as currently structured is not producing this.. 

[fmvizcaino · Accepted solution]

Hi @CDF234557 ,

Attached is an example that does the job.

Let me know if that works for you.

Best,

Fernando V.

[CDF234557]

Thank you!!