nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

OTBI Pivot Table TopN function

Linda Stelling-61686

Content

Hi, can someone provide some quidance on restricting pivot table results (and associated chart) to the Top 10 results based on Nationality by Person Count.

Thanks in advance

Linda

Find more posts tagged with

Comments

Aaron Leggett

Hi Linda,

Have you tried going onto the results tab, right-clicking on the 'Country' cell (could be Nationality for you), Keep Only > Top X > Based on Person Count > 10.

This will generate the relevant SQL into your report and will enable you to then build pivot tables and charts with only the top 10 selected.

I have attached the XML for a very simple report I just built. Have a look at the SQL to see how it works. Simply click on the Advanced tab and paste the XML code into the 'Analysis XML' box. Then click Apply XML and then navigate back to the Results tab.

Kind Regards

Aaron

Linda Stelling-61686

Hi Aaron

Thank you so much for your assistance. I was scratching around in selection steps and calculated items whereas what you have directed me to was so simple (always the case )

Thanks again

Linda

New Announcements

New Events

Analytics - Fusion Data Intelligence: Semantic Model Extensions in FDI: Concepts, Use Cases, and Architecture
Learn how Fusion Data Intelligence supports customization and extensibility across content, data, semantic modeling, and security. This session explains why customers extend FDI, how the FDI architecture enables governed customization, and how to choose among OAC self-service, Data Augmentation, Semantic Model Extensions,…
Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours | Americas and Europe
Agenda Presentation: Salesforce Connector. Unlock the full value of the Salesforce CRM Connector with out-of-the-box subject areas that deliver immediate business insights, and discover how easily they can be extended to meet your unique reporting and analytics needs. Through "art of the possible" demonstrations, explore…
AIDP - Building an AI-Ready Enterprise (Europe and Middle East Time Zones)
Description: Join Oracle and ISG Research to explore what the ISG Buyers Guide™ reveals about the requirements behind successful enterprise AI deployments. ISG will share key findings on the trends shaping buyer priorities, and Oracle will show how Oracle AI Data Platform helps organizations bring AI closer to trusted…