You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

Hide Rows, but use in visualization results (Pivot)

Received Response
edited Sep 11, 2019 5:22AM in Oracle Analytics 1 comment


I would like to use 3 rows of data in a Pivot visualization, but have 2 of the rows hidden. So resulting in a summary by the one row of data.


I am creating a pivot visualization with 3 rows of data, comparing two amounts, but only returning a value when all 3 rows of data are matching.  

Rows:  Account, Order Number, Transaction Number

Values: Transaction Amount (from two sources)

For this pivot, I need the Account, Order_Number & Trx_Number to match between the two sources in order to show an amount as a value.  However, I would like the values to be summarized by the Account row only.  Is this possible?


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!