Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

distinct row


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                      10
000100 John  A12                    1/12/2015  01

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/201511

Any suggestions?



Former Member
Not what you were looking for? View more on this topic or Ask a question