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!
