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
changed property...Application= After Auto Aggregation
and it seems working.
Is that correct?
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.