straight table expression

[#1]

Hi,

We have the following straight table. We also have Compliance as a field with three possible categories: COMPLIANCE, ENFORCEMENT and SUPPORT.

In the table below we would like is to show the count of each category. At the minute showing same one 3 times.

The current expression is Count(Compliance); however, when I've tried to amend to what I think will work If(Compliance)='SUPPORT' I'm not having joy. Please help...

Area	Neighbourhood	Count(Compliance)	Count(Compliance)	Count(Compliance)
Irlam & Cadishead	Moss Vale	490	490	490
Irlam & Cadishead	Falmouth	119	119	119
Irlam & Cadishead	The Glaze	410	410	410

Chris

[MK_QSL · Accepted solution]

Try Something like below..

COUNT({<Compliance = {'SUPPORT'}>}Compliance)

and SO ON.

[luis_pimentel]

Try

COUNT({<Compliance = {'SUPPORT'}>}Compliance)

[#4]

Hi Luis, Manish

Thanks..both answers correct but can only mark 1 one of you as correct...

[MK_QSL]

First Come First Serve