Hi,
is there a way to filter details section of the report created using Matrix report type?
I just want to see rows that contain positive numbers.
Thanks,
Igor
Have you tried using the filter tab in the matrix properties dialog box.
I'd be careful though as each matrix cell is an aggregation of 1 or more detail rows. Depending on the nature of the source data and whether any aggregation is actually occuring you'll want to watch out for filtering underlying negative values vs a negative result of an aggregate.
Can you not do this in the source query?
No comments:
Post a Comment