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

Displaying all months in pivot view (even though no data in some months)

Received Response

13

Views

1

Comments

User_JL3CW

User_JL3CW Rank 6 - Analytics Lead

Nov 10, 2017 2:39AM edited Aug 13, 2024 5:55PM in Oracle Analytics Cloud and Server

Hi all,

Is it possible to always list all months,even when there no quantity (measure) in that month in pivot view?

I am using OBIEE 11.1.1.7 version.

Regards,

Chandra.

0

Answers

Joel Rank 8 - Analytics Strategist

Nov 10, 2017 3:57AM

Open your Pivot Table properties and select Null values settings as appropriate

0