Set Analysis...again...

[#1]

Hello All!

I have a table with transactions. Each transaction have a CompanyID and a date. For a specific period I would like to count all CompanyID that also are found in previous periods. That is, I would like to count all repetitive CompanyID's per period.

I have an expression like this:

=count({$< CompanyID = {"=count({1<Date={'*'}>} CompanyID) > 1"} >}CompanyID)

This expression should count all CompanyID that also could be found in on other dates. What I would like to count is all CompanyID that also could be found on all previous dates from the made selection. That is, if the selection is August 2010 I would like to count all CompanyID in August that also could be found in all dates previous to August 2010.

Any suggestion how to change my expression is appreciated.

Br

Cristian

[danielrozental]

It should be something like

=count({$< CompanyID = {"=count({1<Date={"<$(=date(max(date),'mm/dd/yyyy')"}>} CompanyID) > 1"} >}CompanyID)<div></div>