"Pivot Table."

ratheesan

Hi,
I have two attributes sex and region.The sex column contains 'F' and 'M'.The region column contains 'North','East','West' and 'south'.I would like to prepare a table such that its row is sex and column is region and the values are counts.I tried with aggregation operator ,but not getting the required table.

Thanks
Ratheesan

land

Hi,
I guess the name should point you to the Pivot operator.

Greetings,
  Sebastian