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?