Max(Date) vs. Set analysis?

Anonymous — Wed, 02 Dec 2015 14:57:25 GMT

Hi,

I have the following problem and I have you know the answer:

In a fact table I have, for example, a few records.

Bases on Time selections I want the correct Amount per CustomerNr and PolisNr.

For example:

When I selecting year 2015 i want to see an Amount of 750 + 500 + 350 = 1600

When I selecting year 2015 and Quarter 1, I want to see 950

When I selecting year 2015 and month 9, I want to see 500 + 850

When I selecting year 2015 and week 38, I want to see 850

When I selecting year 2015 and day 1-9-2015, I want to see 500

I hope you can give me an answer!

Best regards,

Arjan

Re: Max(Date) vs. Set analysis?

swuehl — Wed, 02 Dec 2015 20:00:22 GMT

Try

=Sum( Aggr( FirstSortedValue(Amount, -BookDate), CustomerNr, PolisNr))

martijn — Thu, 03 Dec 2015 14:44:32 GMT

That what Swuehl says

Anonymous — Thu, 03 Dec 2015 15:22:58 GMT

Thanks Swuehl!