I may want to visually limit the data I am including in a pivot or report by a data dimension that I don't actually want included as a row/column/cell in the resulting pivot / report.
For instance i might want to create a view of submitted ideas, on a timeframe and show one view of internal requests and one of external.
Thank you for the idea. It is currently possible to add filters even on information that is not included in the report. See the Choose your data columns and filters section of this article for more on how to add filters: https://www.aha.io/support/roadmaps/strategic-roadmaps/analytics/pivot-table
If a field you are trying to filter on is not appearing as an option, this article will provide more guidance on how the filter options are determined: https://support.aha.io/hc/en-us/articles/204984169-The-Add-filter-function-doesn-t-allow-me-to-filter-by-any-data-column