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.
2010 : Jan 30,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?
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.