Hi everybody,

I did it through coding a VBA macro in Excel (using a knapsack first fit algorithm). It was quite easy to do it by coding. I only had to...

Hi Lowell,

Thank you for your ideas. You were right. X corresponds to the retention days. In addition to what I explained, I must say that our SAP environment runs over...

Hi Lowell,

I am not trying to make the solution harder. It is a real world situation.

The table in question is a SAP ECC Add-on "standard" table that establishes relationships with...

Hi Bala,

As far I could understand my problem is the same described in the challenge. Unfortunately, the last post is dated of October 19, 2009 and no solution was provided...

Hi Lowell,

Thank you for your help, but I had already tried to use NTILE with no success. The problem is that is creates overlapping groups (as the creation field holds...

The outcome I need is something like:

Date; Count

01/21/2013; 248,389

02/17/2013; 229,111

04/02/2013; 249,632

Hi,

Does anybody have a solution for this problem?

Many Thanks!

Hi Lowell,

Yours clever solution generates a very close output to what I am looking for. However, I made 2 mistakes for which I offer my apologies.

First, actually the Route ID...