Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OTBI Pivot Table TopN function

42
Views
2
Comments
Linda Stelling-61686
Linda Stelling-61686 Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence Forum

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

 

Comments

  • Aaron Leggett
    Aaron Leggett Rank 5 - Community Champion

    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
    Linda Stelling-61686 Rank 3 - Community Apprentice

    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 smiley)

    Thanks again

    Linda