Pivot Chart Data from external data source

[VRA]

Hi all,

I am trying to create a pivot chart to extract data thro
an MS SQL database which is of the form:-

Country City House Age
XXX yyy 1 C
XXX yyy 1 C
XXX yyy 1 T
XXX yyy 1 T
XXX yyy 1 T
XXX yyy 1 A


I need to get the data in the form:

Country City House C T A
XXX YYY 1 2 3 1

and further create a chart selectable on a per house basis.

Is this simple to implement?

thanks,
VRA