Forum Discussion
jpereztang
Helper I
Helper IWeekday Last Year Comparison
Hi everybody ! I have a requeriment that i don't know how to achieve. Question is simple, how can I compare this year sales with exactly the same weekday sales of last year. take for instance, To...
vapid128
Solution Specialist
Solution SpecialistYOUR DATE LIKE THIS TABLE:
create weeknum and year colnum
and
SUMMARIZE(weeknum,year,"total sales", sum(sales))
last year = lookupvalue([total sales],[weeknum],[weeknum],[year],[year]-1)