Hide Column in Grand Total row — Oracle Analytics

Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Analytics Cloud and Server

Categories

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

Hide Column in Grand Total row

Received Response

21

Views

3

Comments

User_ZZQJ0

User_ZZQJ0 Rank 4 - Community Specialist

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

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 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