we have an entry for every product abt its entry and
shipment dates , i just want to know the time taken to
ship the product.. i mean if the product is shipped in a
day or two or three...

i got my query as

sum(tail(nonemptycrossjoin([ship date].[week].
[suntosatday].members),1),[members].[day count])

but its displaying the output for all date ...i want it
for current date.

is there any chg i need to make in my query ?

thanks in advance