Display the Top 5 Amount for that Year in a report

[#1]

Hi,

I am using QV11 and Excel as data source.

Below is the sample data from which i have to design a report:

SCHEME	CIRCLE	AVERAGE AMOUNT
SWIFT384_550	NewYork	1650
SWIFT384_550	North Carolina	1650
Zapper512+_699	Pennsylvania	992
INF1000_992	Pennsylvania	1680
SWIFT256+	Pennsylvania	716
ZAP512_771	Pennsylvania	550
SWIFT384_550	Pennsylvania	257
Zapper640+_774	South Carolina	440
Infinity_649	Texas	992
INF1000_992	Virginia	2610

My requirement is:

Say, For Year 2012 - CIRCLE "Pennsylvania" will have 5 different SCHEME's. For all the 5 different schemes i need to display the Top 5 Amount in the form of report.

                    1680

                      992

                      716

                      550

                      257

How to achieve this?

Also suggest me which type of chart will be good to show this data?

( SCHEME data count - 82 & CIRCLE data count - 8 ). No idea how to display the SCHEME in the Line Chart. As of now i have taken in X axis.

Thank You.

[senpradip007]

Hi Vinodkumard,

According to your problem I've attached one file, hope it'll be helpful to you.

With Regurds.

Pradip

[#3]

Pradip,

Thanks a lot, but i will not be able to open the file as i am using the QV11 Personal Edition(Free Edition).

Can you provide me the solution in the Post itself?

[Anonymous]

Hi Vinod,

I don't have a brief idea of your model but based on the existing data you should go for a straight table:

Dimensions: Circle and Scheme

Expression: Average amount.

Sort on: Average amount - Numeric tick with Descending

This should help you.

[Sokkorn]

Hi,

Try with this screenshoot

Regards,

Sokkorn

[senpradip007]

Hi Vinodkumard go through the image file... you'll get your answer.

[#7]

That works. Thanks for your solution Pradip.

[#8]

Thats Working Sokkorn. Thank You.

[#9]

Thank You rathod for your solution.

[#10]

For the same, i am using Combo chart - CIRCLE as Bar and SCHEME as Line.

Dimensions - CIRCLE

                    SCHEME

Expressions - AVERAGE AMOUNT

In the chart i am able to see only the Line but not the Bar chart. Where am going wrong?

Kindly suggest.