I am trying to customize an existing
Report to filter based on a formula field. It was created with a
Custom Report Type of
My Object with Child with Grand-Child. Now we want to filter it based on a custom field which we can match against
$User.Username to determine if it should be displayed (when it matches). We can write this formula at any of the three levels, but it is not showing up in the available fields to filter on. Is it not possible based on this report type?
Text as the formula type, on all three objects. None of them are allowing me to filter, despite the fact that some of the pre-existing formulae seem filterable.