Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please help
please provide a sample dataset and also an example of the output you are looking for?
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.
hi
May be this
sum( {<Date = {'=$(addyears(Date,-1))'}>}
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 |
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?
Hi G3S
Yes, i am looking to match the day+month to be the same but year to be last year.
Regards