Creating an inventory

[ValeriaBonini]

Hi to everyone, i need to create an inventory with the cumulative sales based on a specific date.

for now, i uploaded a table with product name, product qty and date and used the cumulative formula:

=RangeSum(Above(TOTAL Sum(qta), 0, RowNo(TOTAL)))

But if the user select a date from the list, I would like to see ALL THE PRODUCTS with the data < or = to the one selected and not only the products with that data like this:

How can i obtain this result?? (without having to select manually allthe dates!)

[Lisa_P]

In your chart, your first measure 'qtatot' can have set analysis in it to limit the dates.

Insert this before the field being aggregated eg Count({<data={"<=$(=Max(data)")}>}qta)

[ValeriaBonini]

Can you specify where do I have to add it? 

[Lisa_P]

Go tot the table and find the qtatot column in the Data section of the properties.  Modify the expression there to include the {<data={"<=$(=Max(data)")}>} before the field being aggregated