Date range using YearQuarter

[BootCam]

Hi, 

I need to make a range using yearquarter like this:

2016-Q1  - 2016-Q2 if the users selects this way, other than that if they selects 2016-Q1 they will see the current selections and previous period 2015-Q1 numbers.

But when they selects the range as mentioned above like  this  2016-Q1   -  2016-Q2 , the numbers of this will show the current range selections and the previous period range numbers for 2015-Q1  -  2015-Q2.

Data:

Customer, QuarterYear, Sales
AD, 20151, 200
AD, 20152, 300
AD, 20153, 150
AD, 20154, 130
AD, 20161, 460
AD, 20162, 340
AD, 20163, 560
BD, 20151, 250
BD, 20152, 370
BD, 20153, 160
BD, 20154, 135
BD, 20161, 466
BD, 20162, 390
BD, 20163, 570
CD, 20151, 210
CD, 20152, 323
CD, 20153, 145
CD, 20154, 136
CD, 20161, 467
CD, 20162, 343
CD, 20163, 568

Thanks,

BootCam

[BootCam]

Ah I see! Its the selection of the field that mattered. I just tested and it looks good!

Thanks for your help Sunny!

Best,

BC

[sunny_talwar]

Happy to help 🙂

[BootCam]

Your rank in the community tell it all how helpful you are in the community! 🙂

Thumbs Up!