I have 3 columns product,date,sales
There are 3 products.
Each product has 5 years of data month wise
i want to create a new column and if any products last year(12 months) sales value is 0 I should update the value in the column as discontinued for that product..
How can this be acheieved in Alteryx
Solved! Go to Solution.
In the above output the solution fetches last year's records.but I want to fetch last 12 months..
Eg., if the data is till july 2021..last 12 months would be july 2020 to july 2021..
if the data is till feb 2020..last 12 months would be july 2019 to july feb 2020..
and also I should be able to change number of months I fetch...
sometimes I might want to fetch last 4 months also