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


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.



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.


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