Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to compare the orders for all weeks
I have two years of data 2015 and 2016
i am unable to compare 52 week of 2015 and 8 week of 2016.
i am using this expression
=sum({<Year_UP = {$(=Max(Year_UP))},Week_UP = { $(=Max(Week_UP)-8) },Week = {"=$(=Max(Week_UP))"},Year=,Month=,Quarter=>}Orders)
Regards,
Joshua.
FYI
Hi mrkachhiaimp
Bro i am using personal edition .
Are your week selection is Week_UP or Week?
I mean when you are saying that you have selected week 20... that is Week_UP 20 or Week 20?
Hi Manish,
Week_Up=20
It's too much confusing... better if you provide an excel file with the selection and output you require with better explanation.
Hi Manish,
I will prepare the excel bro wait.
Hi Manish,
PFA
Every Week_Up has 12 forecasted week,Now I want to find the orders for week_up=1 year=2016 which has been forecasted on week_up=46 ,year=2015 ,
the answer is 33
Every Week_Up has 12 forecasted week,Now I want to find the orders for week_up=1 year=2016 which has been forecasted on week_up=46 ,year=2015 ,the answer is 33
Not understood this sentence..
I understood that for every Week_Up you have 12 forecast week.
But not understood
I want to find the orders for week_up=1 year=2016 which has been forecasted on week_up=46 ,year=2015 ,the answer is 33
Hi Manish,
Week_Up is my calendar,
when user selects week_up=1 and year=2016
then i want to show the orders for forecastweek=1 which has been forecasted 8 weeks before i.e in week_Up=46 and Year-2015.
46 | 46 | 2015 | 54 |
46 | 47 | 2015 | 54 |
46 | 48 | 2015 | 54 |
46 | 49 | 2015 | 54 |
46 | 50 | 2015 | 54 |
46 | 51 | 2015 | 54 |
46 | 52 | 2015 | 54 |
46 | 53 | 2015 | 54 |
46 | 1 | 2016 | 33 |
46 | 2 | 2016 | 33 |
46 | 3 | 2016 | 33 |
46 | 4 | 2016 | 33 |
when user selects week_up=1 and year=2016
The output should be 33.
When user select Week_Up = 1 and Year = 2016, you have below data..
Week_Up | Forcastweek | Year | orders |
1 | 1 | 2016 | 84 |
1 | 2 | 2016 | 19 |
1 | 3 | 2016 | 19 |
1 | 4 | 2016 | 19 |
1 | 5 | 2016 | 19 |
1 | 6 | 2016 | 19 |
1 | 7 | 2016 | 19 |
1 | 8 | 2016 | 19 |
1 | 9 | 2016 | 19 |
1 | 10 | 2016 | 19 |
1 | 11 | 2016 | 19 |
1 | 12 | 2016 | 19 |