expressionproblem

[#1]

I got a problem with an expression =count(item='a') or is it = count(item)='a' - either way it doesnt work for me.

I got a small test spreedsheet with 2 columns YEAR and ITEM.

YEAR ITEM
2008 a
2008 a
2008 b
2009 a
2009 b
2010 a
I want to make a chart with YEAR as dimension af only showing how many ITEMS a there is?

[deepakk · Accepted solution]

try this expression

count(If(Item='a', item)

Deepak

[#3]

Deepak - thanx it works like this

count(If(Item='a', item)), - you missed the last )

regards it solved my problem

[johnw]

Set analysis is faster if you have a lot of data and are using version 8.5 or above:

count({<item={'a'}>} item)