Hide Rows, but use in visualization results (Pivot)

1124711

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?

Thanks!

Version

DV for Desktop Version 12.2.5.3.0

Aman Jain-Oracle

Hello Kavin,

If I have understood your question correctly, you are trying to get value for Transaction Amount column based on some calculation on the other 3 columns if yes  then create a new calculation column and write a case when condition in the formula(logic) .

Below is an example of CASE WHEN condition :

CASE WHEN "Sales Facts"."Amount Sold" > 600000  THEN 'Big' 
WHEN "Sales Facts"."Amount Sold" > 300000  THEN 'Middle' 
 ELSE 'Small' END

Hope this helps!

Regards,

Aman Jain