Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please i need to show all the available stock .
for example if i choose March 2014.
i have to see all available stock.
available stock = car with received date < march 2014 and delivery date should be after march 2014, so it is still on stock.
Attach two calenders for received date and delivery date
Hi,
First Add only the "Variant" as the Dimension.
then in the expr add
COUNT({<Recieved_Date ={'< Date(01/03/2014)'},Delivery_Date ={'>= Date(01/03/2014)'}>}Stock_Number)