0 Replies Latest reply: Aug 19, 2016 1:23 PM by Paul Montalbano RSS

    Managing Mutually Exclusive Data

      Hello! I need to present data in a table showing the total number of row records per column, but because some of the row data is mutually exclusive the data will only show the the row where the flag is enabled. This behavior is a result of the way in which the data is structured within the database record. So, if we visualize a bushel as the record, the bushel may only be filled with apples or oranges, but never both. As you may have guessed, this control is managed via a flag. So, when I ask to show all apples and oranges in this bushel, only one or the other is displayed in my table's current config. Is there a way to join rows from different tables, or a way to have this display use an "or" function rather than an "and"? Of course, I appreciate any other ideas you may have - thanks!