Reporting requirement

Hello experts,

In a requirement I need the following output

2007 .................................................................... .................similarly for 2006

Month..........Percentage .........Number of invoice............Number of invoice

.................. of invoice.............paid on time...................not paid on time

..................paid on time..............................................................................................................

01...................80........................80 ..............................20

02...................78 .......................78 ..............................22

03...................75........................3 ...............................1

...

....

I have calculated and populated a field(A) in cube which contains the value - time taken for clearing a invoice.

So Invoice paid on time means (A) < 30 days

Invoice not paid on time means (A)> 30 days

So for every month I just need teh count of invoice paid on time and not paid on time and I need to calculate the percentageof invoices paid on time.

Any idea how the above report can be acheieved?

Regards,

B

Edited by: B R on Oct 22, 2008 10:51 AM

Edited by: B R on Oct 22, 2008 10:53 AM

Edited by: B R on Oct 22, 2008 10:54 AM

Edited by: B R on Oct 22, 2008 10:56 AM