Query About Charts

[#1]

Hi, Good Morning All,

I'm practising charts.

Confused about what dimension i should take,

I have loaded a 'XL' File,

Loaded Table is 'Customer' and fields are

               Customer:

                    LOAD [Customer ID],

                              Country,

                              Customer,

                              Address,

                              City,

                              Zip

               FROM

               (biff, embedded labels, table is Sheet1$);

I have loaded this table and selected chart and Dimension as 'Country' and then i click Finish, now i see chat is displayed Empty.

Why did i got this issue.....?

What is the mistake that i have done here.

[#2]

Hi Balaji,

Its not working, i took Dimension as 'Country' and Expression as 'count(DISTINCT[Customer ID])'.

Regards,

Narsing Lal.

[#3]

Hi Mark Little,

It worked, Thanks.

I took Dimension as 'Country' and Expression as 'count([Customer ID])'.

Grate efforts.

Regards,

Narsing Lal.