To add a step inside a column condition-wise

Ankan Chanda

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 put this condition and calculation inside the CASE expression?

Thanks and Regards

Ankan