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)
SummaryI 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?