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

how to hide grand total column fake measure column

Received Response
123
Views
14
Comments
2»

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    The pivot is a valid point. But again it takes the approach ad absurdum. What would a char do inside the data grid of a pivot?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    To be clear. This makes sense:

    pastedImage_0.png

    This makes zero sense:

    pastedImage_1.png

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    I understand your point and don't disagree. But, I have occasionally created "fake measures" as the OP called them, such as Max(Order Priority by Order#) in order to take advantage of the greater formatting flexibility that a pivot has over a table.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Oh of course, no problem there at all. But a measure doesn't have a char as an output. Not sure how you measure or aggregate "blue", "red", and "green" ;-)