Forum

This content is now out of date.

Visit Our Community

About Top N Funtion


Hi, I have a question for Top N Function.

I want to select and order Top 5 months by year.
For example,

2010 : Jan 30,000
Mar 40,000
May 50,000
Nov 80,000
Dec 40,000
2011 : Feb 20,000
....
....
....
....
2012 : Mar 10,000
....
....



For this result, I used Top N function as you can see the picture I attached.

However, the result was not same with what I expected.
They showed only 5 lines which included whole years and months.

What should I do in this case?
Here's the images.

Forum image

Forum image

Forum image



Hello Daehwan,

I think you can get what you are after by using 'Sections'. Just drag your year field into sections.


Forum image



You can then apply your Top N Function to the Sum Invoiced field. You should get the following results.


Forum image


I have chosen to hide the Rank Column on my report.

Please let me know if this works for you or if I have misunderstood your question.

Thank you,

Kyle