cancel
Showing results for 
Search instead for 
Did you mean: 

Display the Maximum date value

Former Member
0 Kudos
35

Hi,

I want to create a report that showing for each customer what the last renewal date is. For example, the customer can get a product's license for one year, so if he have 3 licenses for the last 3 years then I want to diplay only the license of the last year.

My question is, how can get the maximum buying date for each customer?

Thanks,

Mohamad.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

This is kind of a hail mary, not sure if it would work but...

you could process the date as a KF using replacement path, then set that column aggregation to Max value. That way, the largest value (date) appears.

Former Member
0 Kudos

Hi,

Have you tried with a condition ?

In condition you can use the operator TOP N ...

Hope it's help

Aleksi