How Can I do this set analysis?

[Anonymous]

Hi all,

This Field "CATEGORY" has three records namely Laptop,Desktop,Workstation.And what i basically want to count the total number of Laptops, Desktop and Workstation seperately to display them.

Thanks

[CELAMBARASAN]

Hi,

     You mean like this

     Count({<Category={'Laptop'}>} FieldName)

     Count({<Category={'Desktop'}>} FieldName)

     Count({<Category={'Workstation'}>} FieldName)

Or use Straight table have category as dimension

     Count(FieldName) as Expression

FieldName can be any unique field or You can use Category

Celambarasan

[Anonymous]

Thanks Celambarasan for the quick response awesome!