How can i count all records until a specific year?

[carlos13]

I need to count all records (Cliente) for all transactions up until a selected year, i.e. a user selects a year  and wants the count Cliente for all year up to the selected one. Plus i will need the same function for the dimension year.

Any suggestions?   set analysis is needed? and how?

[Anonymous]

count({<Year={"<$(=max(Year))"}>}transactions)

[carlos13]

if I have a dimension excludes year senior , I need count customers in all the years he has more customers new the selected year

[Anonymous]

possible years 2010, 2011, 2012.

if you select 2012, you want a count of customers that exist in 2012 and not 2011 or 2010.

does that accurately reflect your requirements?

[carlos13]

possible years 2010, 2011, 2012., 2013

if you select 2012, want a count of customers that exist in 2012 more 2011 and 2010 and not 2013.

is to have a year selected all customers have, more all customers who  had in previous years

[Anonymous]

count({<Year={"<=$(=max(Year))"}>} [field])

The above expression will count all customers in every year excluding any years greater than the selected year.

If the dimension is the field "year", then you will see the count of customers for each year.