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

To add a step inside a column condition-wise

Question
9
Views
0
Comments
edited Jul 22, 2021 6:17AM in Oracle Analytics

Content

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.

Register

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