Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
TOPN Function in OTBI — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

TOPN Function in OTBI

Question
11
Views
0
Comments

Summary:


Content (required):

Hi,

The ultimate requirement is to create a dashboard;

Analysis 1 - Annual Revenue in a Bar chart

Analysis 2 - Revenue for each cost center in the year prompted (Bar Chart)

Analysis 3 - Top 5 revenues for the cost center prompted.

However, when analysis 3 is run, the ranking is done based on the cost center WITHOUT considering the year. For the ranking I have used TOPN("Base"."Base Equivalent Period Net Activity"*-1,5 BY "Cost Center Segment"."Cost Center Description"). How do I group this with year?


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!