Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Suppress Grand Total on Attribute (Calculated Col)

Accepted answer
22
Views
1
Comments
Jayko Paten
Jayko Paten Rank 5 - Community Champion
in Oracle Analytics Forum

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?

Tagged:

Best Answer

  • Federico Venturin - Oracle
    Federico Venturin - Oracle Mod
    Answer ✓

    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).

    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).