Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› 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
21
Views
1
Comments
User_JL3CW
User_JL3CW Rank 6 - Analytics & AI Lead
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.

Answers

  • Joel Acha
    Joel Acha Rank 8 - Analytics & AI Strategist

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

    pastedImage_0.png