4 Replies Latest reply: Feb 25, 2015 1:23 AM by Boris Chigirintsev RSS

    Beginer Question. How to fix one filter criteria?



      I have a table and a few filters, such as : date , ship name, company name and others.

      In table I bring the product name and the total quantity produced by all ships, companies and so on (Sum ([Amount])).


      Needs to be done so that the summation of data were taken only from the latest date selected. If nothing is selected - that for the maximum date.


      I tried this function : Sum ({<Date = {"= Max([Date])" } >} [Amount]). The result was the same as in the function Sum ([Amount]).


      Where am I wrong?