Count of a blank field is incorrect for only 1 of 6 columns
I have a table in my new application that displays the sum of instances of the detail rows that that map to a "Type". The last column "Other" is incorrect in the display table. For now, all values for it are blank (instead of the 'X" like in other applicable columns). It appears to be a sum for each of the other counts in that row. The expression is identical to the others that work, substituting 'Other' for 'Soap', 'Lotion', etc. of course.
How do I get that count to be accurate like the others (it will be 0 so blank like the other blank cells in the output)? Is "other" a reserved word or something? Is the this right most column a total column by default?
Here is my data, chart display output and expression being used:
Reference table values:
Type
Summed Type
Soap
Lotion
Towels
Rug
Bedding
Other
Condo
Owned
X
X
X
Rental
Non-Owned
X
X
X
X
Room Only
Non-Owned
X
X
X
X
X
House
Owned
X
X
X
OUTPUT:
Type
Summed Type
Soap
Lotion
Towels
Rug
Bedding
Other
Condo
Owned
9
9
9
9
Rental
Non-Owned
43
43
43
43
43
Room Only
Non-Owned
17
17
17
17
17
17
House
Owned
38
38
38
38
TOTAL
107
98
60
26
107
107
Expression: Count({<Other={'X'}>}[TicketType])
I have moved it to not be the last column and have also changed the column name, but results were the same each time.
Thank you for your help! I am stumped on this one!
