Adding Last year values in advance into the colum

[mandilicious]

Hi All,

Please help. I would like to have last year values to be added in advance into Last year column?

Below is how report look like.

Regards

[mandilicious]

Please help 

[G3S]

please provide a sample dataset and also an example of the output you are looking for?

[mandilicious]

Thank you very much for your respond. I really appreciate it.

Below is an example of my output. Last year data is existing so i would like it to be prepopulated for there entire weekdays and as for Actual orders they will come daily is fine.

[brunobertels]

hi 

May be this 

sum( {<Date = {'=$(addyears(Date,-1))'}>}

[mandilicious]

Hi Brunobertels,

Thank you for your help.

I used what you shared but it does not pre-populate the last year values,

Below is what is the true picture from dashboard.

My delivery Date start tomorrow which i expected Actual Order to be zero and Last Year orders to be pre-populated like below table.

I guess i need to pre-populate the Delivery Date as well to be able to get Last Year Orders?

Delivery Date	Weekday	Actual Orders	Last Year Orders
20/09/2023	Wed	0	500
21/09/2023	Thu	0	400
22/09/2023	Fri	0	300
23/09/2023	Sat	0	200

[G3S]

do you have the dataset for last year? 

are you looking to match the day+month to be the same but year to be last year?

[mandilicious]

Hi G3S

Yes, i am looking to match the day+month to be the same but year to be last year.

Regards