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
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