What modification I need to make in the following query to use in an older version of Tableau? I was using a newer version in which "IN" can be used for grouping, but the workbook isn't working in an older version due to that.
SUM(IF [Suborder Item Id]>0 AND
LEFT([Type Key],4) IN ('H.ES','H.WC','H.DP','H.AN','H.RQ','H.QL','H.CT','H.PD','H.OD','H.EU')
THEN [Count] END)
2 risposte
You'll have to do a series of explicit IF statements, one for each of the values you want to test for.
So:
IF LEFT([Type Key],4)='H.ES'
OR LEFT([Type Key],4)='H.WC'
...
THEN [Count]
END