Hi All,
I have 3 months of sample data and going forward more data will be added.
Could you please help me to build a workflow which tracks the Prop Code Changes on month over month Basis.
Say my current reporting period is 30/09/2016.
Three scenarios to execute-
1) New Prop Code in the current month (30/09/2016.) - compare Prop Code with previous month (if previous don't have=new, else=old)?
2) Prop Code suspended in the current month (30/09/2016.) -
3) Prop Code was same - compared to previous month? -
Many Thanks
Hello,
Thanks ,There is another thread on this one it was by mistake my apologizes
see my Input Dat and expected Output Data but this is where I'm facing challenges to get the desired result. and always this has to be dynamic means whatever we filter on the Dates column that will be your current Month and it should compare against previous month.
Many thanks