Formula to get Top 5 categories based on a criteria

Vipusha Chandrakumaran

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

Amrita Gupta-Oracle

Hi @231094,

Please try below -

TopN("Base"."Base Equivalent Period Net Activity" ,5 BY "<Balancing segment column name>"). This should give you something like below -

Vipusha Chandrakumaran

Hi Amrita,

It worked. Thank you so much for the prompt response.

Thanks,

Vipusha

Amrita Gupta-Oracle

Thanks Vipusha