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

Look Back
Formula to get Top 5 categories based on a criteria — 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

Formula to get Top 5 categories based on a criteria

Accepted answer
12
Views
3
Comments
in General Transactional Reporting (OTBI) 3 comments

Summary:


Content (required):

Hi Experts,

We have a requirement to get Top 5 Expenses based on the balancing segment value. The Top 5 expenses can be obtained using the below Formula

TopN("Base"."Base Equivalent Period Net Activity" ,5)

In addition to the above we also want it to be grouped based on Balancing segment values.

Example - Top 5 expenses for BSV 1, Top 5 expenses for BSV 2 etc.

Please advise as to how this can be catered through the formula.

Thanks,

Vipusha

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


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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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