Max(Payment_due_date) use this in report level create a variable or in cell

I need to select the rows based on the
latest 'Payment_due_date' column value.
Let's say I have a Deski report with 3 columns:
Payment_due_date,
Cust_Name,
Oustanding_Amt.

Report is like this:
=====================================
Payment_due_date,Cust_Name,Oustanding_Amt
02/28/11 , Bob, 115
03/31/11 , Bob, 90
02/28/11 , Mike, 120
02/28/11 , Susan, 220
05/31/11 , Bob, 80,
03/31/11 , Susan, 70
05/31/11 , Mike, 220
05/31/11 , Susan, 120
04/30/11 , Susan, 130

So,we would like to see (based on latest Payment_due_date)
==================
05/31/11 , Bob, 80,
05/31/11 , Mike, 220
05/31/11 , Susan, 120

Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe.
If we use Max(Payment_due_date),we do get one row but then,
the column 'Oustanding_Amt' sums up.
Not allowed to use do SQL Override .Context Operators
aren't working.

Thanks in advance:)

Question Posted / gs2kumar@gmail.com

3 Answers
7202 Views
I also Faced
E-Mail Answers

Answer Posted / gs2kumar@gmail.com

Max(Payment_due_date) use this in report level create a variable or in cell.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can more than 1 metric be applied on an analytic in business objects?

2225

Explain when we use aggregate awareness function in designer?

1091

U r project in which stage in implementation?

2579

Explain what sort of existing documents should business analysts refer to when starting on a new project?

1049

Explain what is the difference between business requirement document and use case document.

1074

What is report template in b.o?

1076

What is the difference between slice and dice and cross tab report?

1113

How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

2349

webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

4452

Explain is there any other repository domains rather than universe, security, document?

1180

can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1436

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1920

8. How much supervision have you typically received in your previous job?

2312

Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

1100

Explain difference between zabo and webi?

1148