OAC DV: A complex calc column (nested CASE statements with a Y or N as output) shows as an Attribute in the Data Panel, but shows up as random Y or Ns on the Grand Total.
Anyway to suppress this?
Hi @User_Z0VKD ,
This usually happens when the CASE statement is based on a measure column (e.g. CASE WHEN Sales > 1000 THEN 'Y' ELSE 'N' END).
CASE WHEN Sales > 1000 THEN 'Y' ELSE 'N' END
To suppress the value from the Grand Total you have to transform each measure in your CASE statement to an attribute using the ATTRIBUTE function (e.g. CASE WHEN ATTRIBUTE(Sales by Category) > 1000 THEN 'Y' ELSE 'N' END - assuming that your visualisation contains only the attribute column Category).
CASE WHEN ATTRIBUTE(Sales by Category) > 1000 THEN 'Y' ELSE 'N' END
