Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Seems a simple one but can't seem to find the answer. I have an order chart with all the order weeks running along the X axis but I only want to show those from the current week going forward. I already have the current week stored in another field.
Thought I'd try put something like [orderweek]>=[currentweek] in the dimension field but that didn't work. Can someone help?
Hi,
I think below code should work:
if(orderdate>currentweek,order,null())
also check the option for suppress null values.
HTH
Sushil
Hi,
can you transfer that current week into variable and compare value like [orderweek]>=[Variable name].
Thanks
piyush
Hi,
I think below code should work:
if(orderdate>currentweek,order,null())
also check the option for suppress null values.
HTH
Sushil