Filtering the data of the latest date

[horusshih]

Hi

I want to filter the data of the latest date in a databand.

I've tried to use MaxDate function, but I don't know how to set the filter in a right way.

Are there any good advise to solve this problem?

[HighAley]

Hello.

We can suggest you two solutions:

1. You could use Totals functions with CacheTotals enabled.
2. Use a variable.

Please, look at attached reports.

Thank you.

[horusshih]

Hi HighAley

Using Totals functions works in my report.

Thanks for your suggestion.

[HighAley]

Hello.

We are always glad to help you.
Let us know if you need our help.

Thank you.