Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi vikasmahajan
Bro i dont have QV license.
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)
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.
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))
)))))))
Hi all,
Is ther anyother way to solve this problem.