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

Restrict results of new calculated items to certain rows only

Received Response
51
Views
12
Comments
2»

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    I re-iterate my first statement and add: take a step back and think what you are trying to achieve.

    You're too focussed on making it work with a calc item in a pivot while there are other solutions.

  • fabryddorf-Oracle
    fabryddorf-Oracle Rank 4 - Community Specialist

    Yes, I was thinking about other ways but did then the display will be completely different. There are two many pre-calculated measures involved as well as joining of same table.

    I changed the format now and hoping that this maybe would be easier to achieve in new calculated items.

    I would the pickup (06-Apr-18 - 30-Mar-18) to apply only on OTB Figures and exclude LY Figures, kind of $4b-$3B. Is there a way to achieve this? I guess not, correct?

    pivot_calculation.jpg