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.

[ajsjoshua]

Hi vikasmahajan

Bro i dont have QV license.

[er_mohit]

Hi,

the reason is that you have using in expression -8 concept for max week-up field value. so, due to that if we select week 8 or week 7 it doesnot give value. i remove -8 from your exporession.

try this

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

[vikasmahajan]

[ajsjoshua]

Hi mohit,

Bro the logic is like that we r finding the forecasted 8 week before,

if i remove 8 then i dont get the answer.

[ajsjoshua]

Hi Brother,

Lik that willl it works

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

,if(GetCurrentSelections(Week_UP)=2, sum({<Year_UP = {$(=Max(Year_UP)-1)},Week_UP = { $(=Max(Week_UP)-7) },Week = {"=$(=Max(Week_UP))"}>}Orders)

,if(GetCurrentSelections(Week_UP)=3, sum({<Year_UP = {$(=Max(Year_UP)-1)},Week_UP = { $(=Max(Week_UP)-6) },Week = {"=$(=Max(Week_UP))"}>}Orders)

,if(GetCurrentSelections(Week_UP)=4, sum({<Year_UP = {$(=Max(Year_UP)-1)},Week_UP = { $(=Max(Week_UP)-5) },Week = {"=$(=Max(Week_UP))"}>}Orders)

,if(GetCurrentSelections(Week_UP)=5, sum({<Year_UP = {$(=Max(Year_UP)-1)},Week_UP = { $(=Max(Week_UP)-4) },Week = {"=$(=Max(Week_UP))"}>}Orders)

,if(GetCurrentSelections(Week_UP)=6, sum({<Year_UP = {$(=Max(Year_UP)-1)},Week_UP = { $(=Max(Week_UP)-3) },Week = {"=$(=Max(Week_UP))"}>}Orders)

,if(GetCurrentSelections(Week_UP)=7, sum({<Year_UP = {$(=Max(Year_UP)-1)},Week_UP = { $(=Max(Week_UP)-2) },Week = {"=$(=Max(Week_UP))"}>}Orders)

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

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

)))))))

[ajsjoshua]

Hi all,

Is ther anyother way to solve this problem.