Search code examples
cognoscognos-bi

Total row visualisation IBM cognos

i have a list where employees are listed and next to it the clients afther that a 1 or 0 if there has been contact with the cliënts for longer than 3 months

now i want to visualise the list but i cant get the total per employee. i have grouped by employee but that doesn't seem te work.

example:

**Employee     Cliëntname     longer than 3 months**
    1            1              0
    1            33             1
    1            12             0
             **total          1**
    2            2              1
    2            3              1
             **total          2**

can anyone help me with this

Solution

  • Have you tried:

    total([longer than 3 months] for [Employee])