Text box and pivot table expressions

[ajsjoshua]

Hi all,

I am using this expression

=sum({<Year_UP = {$(=Max(Year_UP))},Week_UP = { $(=Max(Week_UP)-8) },Week = {$(=Max(Week_UP))}>}Orders)

which is working fine in text box but its not working in pivot table.

Regards,

Joshua.

[Kushal_Chawda]

try this

=sum(aggr(sum({<Year_UP = {$(=Max(Year_UP))},Week_UP = { $(=Max(Week_UP)-8) },Week = {$(=Max(Week_UP))}>}Orders),LTIM))

[ajsjoshua]

Hi er.mohit

Bro somewhat we r close to the answer but if we check for week_UP 8 or Week_Up 7 its not giving values

[ajsjoshua]

Hi kush141087

Bro For week_UP 9 it showing orders for week 10 ,it should start from week 9 to week 20.

from week_up 10 its ok

for week_UP 8 or Week_Up 7 its not giving values

[ajsjoshua]

Hi Mohit Sharma

Bro somewhat we r close to the answer but if we check for week_UP 8 or Week_Up 7 its not giving values

Re: Text box and pivot table expressions

[ajsjoshua]

Hi Mohit Sharma

Bro somewhat we r close to the answer but if we check for week_UP 8 or Week_Up 7 its not giving values

Text box and pivot table expressions

[ajsjoshua]

Hi Mohit,

Bro somewhat we r close to the answer but if we check for week_UP 8 or Week_Up 7 its not giving values

Text box and pivot table expressions

[sasikanth]

hi,

try this exp in chart

=sum({<Year_UP = {'$(=Max(Year_UP))'},Week_UP = {'$(=Max(Week_UP)-8)'},Week = {'$(=Max(Week_UP))'}>}Orders)

included single quotes

also use weekyear in place of Week_UP  like     WeekYear = {'$(=Max(WeekYear )-8)'} ,

bcz the week number  going into previous year

PFA

[vikasmahajan]

It seems there is some data missing or some problem with LITM dimension if we remove the same you are getting results.

Vikas

[ajsjoshua]

Hi vikasmahajan

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

Regards,

Joshua.

[ajsjoshua]

Hi sasikanth_narne

Bro i am not getting the answer.