Set Analysis - Count for last Date with Data

[AguWolkovicz]

All,

I'm trying to have something working like as follows:

Scenario description:

- Calendar Date has all dates

- Data Date has the dates when something actually happened

- Products Count is just that, the Product count for that date... Count(Distinct SomeID)

- Previous Count Should be the Product Count of the last date when something actually happened.

- Difference should be "Products Count - Previous Count"

The final Table should only have these columns:

- Calendar Date

- Products Count

- Difference

I've been trying several combinations using Aggr and Set Analysis, and I'm struggling with getting even the previous Data Date for a given Date.

Thanks in advance!

Agu.-