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

Hide Rows, but use in visualization results (Pivot)

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

Summary

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.

Content

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?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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