on 06-15-2016 1:52 PM
Hi,
I need to show rows for all values, regardless of count. The table is straightforward. This is what I need it to display:
Value Count
Value 1 2
Value 2 3
Value 3 1
Value 4 0
I cannot get Value 4 to display. Value 4 has no items associated with it in the report, so I'm assuming it would be 'null', but I need it to display as 0.
I've selected the following options on format table:
"show rows with empty measure values"
"show rows for which all measure values = 0"
"show rows for which the sum of measure vallues = 0"
I've also included all values in an advanced sort
When I do a separate count on the value and display I get "Multivalue". Here is the formula =If ([Value]="Value 4";1;0)
Neither of these options worked. Thank you in advance for your assistance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
10 | |
9 | |
8 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.