Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All, I am using QV 11 with Pivot table. My pivot table is having 2 dimensions along with other dimensions also. These 2 dimensions are RequiredDate and DeliveredDate. On my expressions side, I have to display as on Required Date how much qty is Delivered. so I have written the expression as sum({< DeliveryDate = {'<=$(=(RequiredDate))'} >} DeliveredQty) But this expression is not giving me correct qty. If I select the Order date then it gives the correct qty. Please guide me on this.
Try the following.
If not, you could upload an example to make it easier to help.
sum({$<RequiredDate={"=DeliveryDate=RequiredDate"}>} DeliveredQty)
Regards.
See attached example for an explanation.
Thanks to both... But I got the solution as sum({< DeliveryDate = {'<=$(RequiredDate)'} >} DeliveredQty) and it worked fine.