compare current date with previous year date

[riishabhz]

hello everyone

i have date column names as date in the format of yyyy-mm-dd

and it consist of date ranging from 2017-01-01 till today that is 2019-10-09

now i want to compare sum(sales) of today with last year

for ex:-

date          |    sales| lastyear|        sales

2019-10-09| 500$ |2018-10-09| 800$ 

please help 

also i dont want to use calendar script as it is complicated

i want to keep it simple like set analysis.

[StarinieriG]

Hi,

try to use Addyears(Today(),-1) in set analysis

[riishabhz]

hello sir

now date is showing of previous year but how to get sales data in it?

my column for sales data is sales

[StarinieriG]

Sum({<Date = {">=$(=YearStart(Today(), -1)) <=$(=AddYears(Today(), -1))"}>} Sales)

[riishabhz]

sir its showing same sales data as of today.

[riishabhz · Accepted solution]

i have solved it by creating 4 variables like:

currentyearstart=2019-01-01

currentyearend=2019-12-31

previousyearstart=2018-01-01

previousyearend=2018-12-31

and attached calendar to it