Report data issue

[kris123]

Created a simple list report (as in the attachment)
added a filter  Revenue > 500000 and found that the data is not correct
please can you help resolve the report data issue

[kris123]

changed property...Application= After Auto Aggregation
and it seems working.

Is that correct?

[wyconian]

Is it correct? Depends what you're trying to get to.

If you set the filter to be before aggregation (which I think is the default) it will only show you records where the individual revenue is > 500000.  If it's set to after aggregation the report will be filtered where the aggregated revenue value (aggregated on whatever you have grouped by) is > 500000

Before aggregation filters the detail, after aggregation filters aggregated values.

Hope that helps.