Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a pivot table that I need to limit the view to showing records from today through the next two weeks and have it maintain a two week look forward as the days pass based on the Arrival Date field. The chart is not to be affected by any selected filters in the dashboard. I am not sure how to script this condition. The qvw is attached.
Thank you in advance for any assistance.
here is the expression
Sum({< WhseARRIVALDATE= {">=$(=(num(today())))<=$(=((floor(weekend(today(),2)))))"}>}SHIPPEDQTY)
and your document
if you want it to ignore all selections just add a 1 to your set analysis opening
Sum({1< WhseARRIVALDATE= {">=$(=(num(today())))<=$(=((floor(weekend(today(),2)))))"}>}SHIPPEDQTY)
this link should help
here is the expression
Sum({< WhseARRIVALDATE= {">=$(=(num(today())))<=$(=((floor(weekend(today(),2)))))"}>}SHIPPEDQTY)
and your document
if you want it to ignore all selections just add a 1 to your set analysis opening
Sum({1< WhseARRIVALDATE= {">=$(=(num(today())))<=$(=((floor(weekend(today(),2)))))"}>}SHIPPEDQTY)
Thank you Ramon!!!
Smith, the other Approach create e Flag in your Master calender use Calculated Dimension in Pivot table.