Default Value Date on a Table

[Anonymous]

Hi, I have a table built that Im uploading data to daily, it has a Product and a number of units in it. The number of units changes day on day so the Product list changes too. The Products where invventory goes to 0 will stay in the database as it may be refilled.. Im looking for this table to wake up fully as if I have just selected the most recent value date which has the most recent inventory stock updated. meaning that the list will not show all products if there is no inventory that day.

Product List

=Product_Name

Currently have my units calculated as follows:

Aggr(NODISTINCT Sum({<[Value Date]={'$(=Max([Value Date]))'}>} [No. Units]), Manufacturer)

This means that the products with a 0 value are still showing up on the table as

im looking to put a similar value date constraint on the Product_Name list

any help would be appreciated

Thanks

[sunny_talwar]

May be try this

Only({<[Value Date]={"$(=Date(Max([Value Date])))"}>} Aggr(NODISTINCT Sum({<[Value Date]={"$(=Date(Max([Value Date])))"}>} [No. Units]), Manufacturer))

[Anonymous]

That seems to work great.. Thanks for your help

[sunny_talwar]

No problem at all