Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
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
18
Views
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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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