Previous Month value

[Anonymous]

Hi all,

I want to find previous month value

example

Year	Month	Sales
2016	Jan	100
2016	Feb	200
2016	Mar	300
2016	Apr	400
2016	May	500
2016	Jun	600
2016	Jul	700
2016	Aug	800
2016	Sep	900
2016	Oct	1000
2016	Nov	1100
2016	Dec	1200
2017	Jan	1300
2017	Feb	1400
2017	Mar	1500

1) Currently it should show value for Feb 2017

2) If i select Jan 2017 it should show Dec 2016 value

thanks in advance

.

[swuehl]

Have a look at

The Magic of Set Analysis - Point In Time Reporting • Blog • AfterSync