Thanks for your reply but it didn't solve my problem.

I need to create a sheet like this:

I can't create a grid with the customers names on rows.

Any suggestion?

This isn't the correct number.

Using my original calculation:

SUM(

IF

{FIXED [Customer ID] : COUNTD(IF YEAR([Order Date]) = 2011 THEN [Order ID] END)} > 0

AND

{FIXED [Customer ID] : COUNTD(IF YEAR([Order Date]) = 2012 THEN [Order ID] END)} > 0

THEN 1

ELSE 0

END)

/

MAX({COUNTD(IF YEAR([Order Date]) = 2011 THEN [Customer ID] END)})

The result is 43,69% and I already confirm it.

Using the calculation below:

COUNTD customer

 

{ FIXED [Customer Name],year([Order Date]):countd([Order ID])}

 

window sum count

 

(window_sum(

if LOOKUP(min([COUNTD customer]),0) >0 and

LOOKUP(min([COUNTD customer]),1)>0 then 1 else 0 end ))

/

SUM({fixed year([Order Date]) : countd([Customer Name])})

I get the result below:

Which is not correct.

Hi Usman,

I think your solution will solve my problem.

Can you attach your workbook so I can see the how did you get there?

Thank you!

Thank you, Usman.

It's not the exactly same thing that I was trying to achieve but it worked pretty well. My client liked it.

Giorge Caique