on 10-19-2015 7:27 PM
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,
try with right click on the table->format table->checked the checkbox "avoid duplicate row aggregation"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try following formula:
vNotification A = Count ([ID] Where ([Notification Type] = "A"))
vNotification B = Count ([ID] Where ([Notification Type] = "B"))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try defining uour Count variables as measures instead of dimensionl.
Regards,
Rogerio
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.