distinct row

[Former Member]

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,

[amitrathi239]

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

[Former Member]

Amit,

I already tried your suggestion (screenshot attached) but I get the same..

Regards,

[amitrathi239]

Other option is drag the "Notification Type" object in the table and right click and hide this column.

[Former Member]

Amit,

I tried as suggested, but I got the same result as before.  Can calculation context be used here?

TIA,

Regards,

[amitrathi239]

share the screenshot of your table after adding "Notification Type" as a column in the table.You should get the two rows one for A and other for B.

[Former Member]

Try following formula:

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

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

[Former Member]

Hi,

Try defining uour Count variables as measures instead of dimensionl.

Regards,

Rogerio

[Former Member]

Thanks, both my variables (vNotification A & vNotification B) are defined as measure.

Regards,