Forum Discussion
Compare current 4 quartets with previous 4 quarters.
Hi All, Need help on below issue. My Data Set : revenue period --- Both are text fields. 100 2018Q1 200 2018Q1 100 2017Q4 200 2017Q4 100 ...
Im not sure if i got this correct.
You want the differences between revenues from each quarter of this year and last years?
we are planned to compare last 12 months( sum) data with previous 12 month (sum)data,This process we need to automate. If any new data set is refreshed then we need start comparision current 12 month sum with previous 12 months sum.