You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

To add a step inside a column condition-wise

edited Jul 22, 2021 6:17AM in Oracle Analytics


Hi team,

              We are trying to calculate Quarterly data inside 'Add a step' method in a column named Total of a dataset named Total_Sales. Inside the 'Add a step' method we can see the '+' operator is present but inside Aggregate, SUM function is not there . So what we are doing is that we are using CASE(IF) expression but how to calculate the SALES of the four quarters inside the condition area, is beyond scope. Can you please suggest ways we should be calculating the quarters of every year starting from 2015? How to

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!