Data Changes

[suby]

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

[ArtApa]

Hi @suby - Not sure if that is how you wanted to see the output:

[suby]

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