Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

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
21
Views
1
Comments
Jayko Paten
Jayko Paten Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server

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