calculate three different periods

[avishaiz]

i want to create a digital conter that will display a count or a sum of a orders compared to the previous two periods i selected

for example if i choose this year i will get the sum of products for last year and the year before

if i choose last month i will get the sum of products for last years week and the year before

sum for year 2016

sum for year 2015

sum for year 2014

sum for year 2016 week 2

sum for year 2015 week 2

sum for year 2014 week 2

thank you

[Chanty4u]

chk dis

Week this Year vs Week Last Year

[Anonymous]

may be helpful for you?

Set Analysis for Rolling Periods

Set Analysis for certain Point in Time