Highlighting rows in one table when there's a match to values in a second table
Please find the attached file.
Basically, if I select one value for Buyer ID and one for Seller ID, I want to have the rows in the buyer product table highlight if they match with the seller product table
You can't do it in a Table Box, however you can do it in a chart. See attached. The formula is hiding in the Dimension attribute "Background Color". Open the Dimensions tab in the properties, then click on the + sign next to the dimension. The formula checks whether the Buyer Product exists in the list of available Seller Product.
