About Top N Funtion
11 June, 2015
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.
Hello Daehwan,
I think you can get what you are after by using 'Sections'. Just drag your year field into sections.
You can then apply your Top N Function to the Sum Invoiced field. You should get the following results.
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
I think you can get what you are after by using 'Sections'. Just drag your year field into sections.
You can then apply your Top N Function to the Sum Invoiced field. You should get the following results.
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
