Beginer Question. How to fix one filter criteria?

[#1]

Hi!

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?

[jyothish8807 · Accepted solution]

Hi,

If you want only the max date to display then use this expression.

=Sum ({<Date = {'$(= Max([Date]))' } >} [Amount])

Regards

KC

[#3]

Works lika a charm! Thank u!

Can you explain a little bit, why I should use "$" in this case?

[jyothish8807]

you are welcome

So when ever you use any function or variable in set analysis you need to add a $ sign before that to evaluate it.

Over here I am using max function, so to evaluate the max function I used the $ sign.

Hope it helps.

Regards

KC

[#5]

It's really helps!