Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Hide Column in Grand Total row

Received Response

31

Views

3

Comments

User_ZZQJ0 Rank 4 - Community Specialist

Apr 29, 2017 10:07AM edited Aug 13, 2024 6:02PM in Oracle Analytics

Is it possible to hide one cell in the grand total row. I have a requirement to hide this.

Location	Qty	Amount
Russia	12	$100
Turkey	12	$100
Grand Total	HIDE THIS CELL	$200

0

Answers

• 

  Sherry George Rank 7 - Analytics & AI Coach

  Apr 29, 2017 10:42AM

  Hi,

  You can change the aggregation rule to 'None' for QTY measure.

  

  0
• 

  User_ZZQJ0 Rank 4 - Community Specialist

  Apr 29, 2017 1:50PM

  I tried that but the cell values still appear.

  0
• 

  User_ZZQJ0 Rank 4 - Community Specialist

  Apr 29, 2017 2:20PM

  Hi Sherry,

  My apologies. You were actually right. You fix works in a pivot table. I tried it using a table.

  Thanks

  0