how to fetch filed values more than one dimension.....

[#1]

Hi guys...

I have a table like this like this...

Type               model       country

info                xyz            India

complaint      xyz             French 

complaint       xyz            French

Complaint     abc            india

I want to show table like this..

country    xyz

French     2  -->no of complaints.

by using the expression count(if(wildmatch(type,*complaint*),type) I get complaint count as 3

but I want to show country and xyz wise complaint count.

can you please help me guys....ASAP.

Advance Thank you,

Ravi.

[sunny_talwar]

You can do this in  a straight table by adding country and model as dimension and using this expression -> Count(Type)

[settu_periasamy]

Pivot Table?