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