Skip to Content
avatar image
Former Member

distinct row

Greetings,

I have a dimension called Notification Type with values: A, B, C etc.

I created the following variables to count my A, B, C etc.

vNotification A = Count ([ID]) Where ([Notification Type] = "A"))
vNotification B = Count ([ID]) Where ([Notification Type] = "B"))

ID     Name     Room Date Notification A  Notification B 000100 John   A12                    1/12/2015                      1 0 000100 John   A12                    1/12/2015  0 1

When I dragged the variables, the count is correct, but displays as follows:

Following is how I would like the report to display.

ID     Name    Room Date Notification A  Notification B 000100 John    A12 1/12/2015 1 1


Any suggestions?

TIA,

Regards,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 19, 2015 at 06:38 PM

    Hi,

    Try defining uour Count variables as measures instead of dimensionl.

    Regards,

    Rogerio

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 19, 2015 at 08:09 PM

    Try following formula:

    vNotification A = Count ([ID] Where ([Notification Type] = "A"))

    vNotification B = Count ([ID] Where ([Notification Type] = "B"))

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2015 at 08:22 PM

    try with right click on the table->format table->checked the checkbox "avoid duplicate row aggregation"

    Add comment
    10|10000 characters needed characters exceeded