Filter Data Locally within Pivot Tables

Business users can now filter data locally within pivot tables to support more focused and flexible analysis, refining data views without affecting the rest of the dashboard. Local filtering has already been available in aggregate tables and results tables, and this enhancement now extends that capability to pivot view as well. Users can isolate trends, compare segments, and explore data more efficiently while maintaining global dashboard context. Local filters can be applied to both column and row attributes, giving users precise control over the subsets of data they want to explore.

Business Benefits

• Clarity in grouped data: Dimension names in headers make pivot views easier to interpret.
• Focused analysis: Local filters on rows and columns help users zoom into relevant subsets.

Steps to Enable

You don't need to do anything to enable this feature.

Key Resources

Oracle E-Business Suite User’s Guide: Enterprise Command Centers