Making a pie graph based on information from different column

[#1]

Hi there,

How would I be able to make a pie graph that shows the frequency of the drinks mentioned?

This should be easy I guess, I'm just not familiar with the way the data is stored.

thanks!

[its_anandrjs]

Hi,

I suggest if you want to create a pie chart create crosstable of this data and the create a pie chart. In your example

Cola has 3 frequency,

Water has 2 frequency,

Beer has 1 frequency.

Create crosstable like

CrossTable(FV_Cola, Data)

LOAD Id,

     FV_Cola,

     FV_Water,

     FV_Beer

FROM

Source File.

HTH

Reagrds

Anand

[#3]

Thanks man!

[its_anandrjs]

Hi,

Thanks, If you got correct answer so mark it correct so other can see it.

Regards,

Anand