Skip to Content
avatar image
Former Member

Count based on Other Dimension in WEBI

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 26, 2015 at 03:07 PM

    zcount = Count([Day])

    will provide you the output below:

    ReportUserzcountA13A22B12B22C12

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

    Add comment
    10|10000 characters needed characters exceeded