Oracle Analytics was named as a Leader Oracle Analytics was named as a Leader in the 2024 Gartner® Magic Quadrant for Analytics and BI Platforms
Oracle Analytics Cloud May 2025 Update The Oracle Analytics Cloud (OAC) May 2025 update enhances how users generate insights, engage with data, and distribute content
Poll: Oracle Analytics Community Website Satisfaction Tell us about your satisfaction with our newly redesigned Oracle Analytics Community Website.

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

11

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