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]

Not understood what exactly you want to do... can you explain in brief please..

[ajsjoshua]

Hi Manish,

Pls find the sample attached.

[ajsjoshua]

Hi mrkachhiaimp

Bro actually if user select week 8 in Year=2016 it should show orders value  for week 8 which has been forecasted on 52 week of year 2015 .

[MK_QSL]

I still don't get the logic. Can you explain by taking two examples... say select Week 10 and what result you are expecting.. Select week 20 and provide the result you are looking for..

[ajsjoshua]

Hi mrkachhiaimp

If i select Week_Up=10 then it should display orders for week 10 which has been forecasted on week_Up=2

If i select Week_Up=20 then it should display orders for week 20 which has been forecasted on week_Up=12

Its working fine  for these two but its not giving answers for week_Up =8

week_Up =7

week_Up =6

week_Up =5

week_Up =4

week_Up =3

week_Up =2

week_Up =1

[MK_QSL]

But also provide output... I mean sum(orders) you are looking for..

[ajsjoshua]

Hi,

For week_up=20

Forecasted 8 orders=380.8796

[MK_QSL · Accepted solution]

Create a Straight/Pivot Table

Dimension

Week_UP

Expression

=SUM({<Week_UP = {"=Week_UP + 8 = Week"}>}Orders)

[ajsjoshua]

Hi mrkachhiaimp

I am not getting any values.

Regards,

Joshua.