Gauge Chart

[#1]

Dear all,

I have a table :

Company     Date          Money

A         20120830        100

B        20120830         200

C        20120830          300

D        20120830         400

A        20120831         500

B        20120831         400

C         20120831        300

D        20120831         200

How to set two individual gauge charts if I want to show top-two rich companies per date?

Thanks all!

[senpradip007]

Hi

Find the attachment.

Hope it helps.

Regards

Pradip

[#3]

Thank you for your answer!

But any difference if I am using excel file as a database source?

[#4]

And I dont know what the meaning of this statment

Max({$<ComDate={'$(vMaxDate)'}>} Money)

especially "vMaxDate"

Thanks a lot!!

[#5]

But when I used excel instead of hard code the database in script, it does not work.

Pls help!