This content has been marked as final. Show 2 replies
I have two tables, linked by an SKU field. Both tables have multiple lines per SKU.
I created a pivot chart with fields coming just from table A.
I am trying to create an expression that if there is at least one entry equal to "check" in field "criteria" of table B , it shows "check"
but since there is several values in table B for each SKU, which might be either "check" or "to be checked", I end up with unreliable results.
What I am using is:
but indeed is giving unreliable results.