DBCrossTab

Hi,

I have some data from a ADOQuery that contain a value and a contry code.
For example

Value Country
12 NL
25 D
10 D
17 B
35 D
8 A
...

Now I want to display the count of values in a range of 0-10, 11-20, 21-30, ...

The result should be something like
         NL   D    B    A
 0-10     0    1    0    1
11-20    1    0    1    0
21-30    0    1    0    0
31-40    0    1    0    0

Can I do this in a DBCrossTab Object ?

The rows would be the Country code but in the columns I have to put in something like (Value<11), (Value>10 and Value<21), (Value>20 and Value<31), ......


Is this possible ?

Best regards
TL01

Leave a Comment