Week Comparison Problem

[ajsjoshua]

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.

[MK_QSL]

FYI

[ajsjoshua]

Hi mrkachhiaimp

Bro i am using personal edition .

[MK_QSL]

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?

[ajsjoshua]

Hi Manish,

Week_Up=20

[MK_QSL]

It's too much confusing... better if you provide an excel file with the selection and output you require with better explanation.

[ajsjoshua]

Hi Manish,

I will prepare the excel bro wait.

[ajsjoshua]

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

[MK_QSL]

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

[ajsjoshua]

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.

[MK_QSL]

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