Count based on Other Dimension in WEBI

[former_member228575]

Hello all,

I have a requirement in WEBI as below

Report	User	Day
A	1	1st
A	1	2nd
A	1	3rd
A	2	1st
A	2	2nd
B	1	1st
B	1	2nd
B	2	1st
B	2	2nd
C	1	2ND
C	1	3RD

Now what  I want is a variable zcount that count no of times the report is executed

Report	User	zcount
A	1	3
A	2	2
B	1	2
B	2	2
C	1	2
C	2	0

Please Suggest

[arijit_das · Accepted solution]

zcount = Count([Day])

will provide you the output below:

Report	User	zcount
A	1	3
A	2	2
B	1	2
B	2	2
C	1	2

Is the last row (C - 2 - 0) absolutely necessary ?