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
7074 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

U r project in which stage in implementation?

2517

what is document design in boxi,have u participate in that

2186

What are all difference between business objects 6.5 and xi r2?

1033

how get the grand total in master-detail report?

2236

What is the difference between absolute and relative div positioning?

1050

How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

2428

Explain is it the job of a business analyst or systems analyst to draw the class diagram?

1038

What Is The Difference Between Oltp And Olap?

1127

What is the functional & architectural differences between business objects and web intelligence reports?

2414

Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1047

how to prepare the documentation in business objects and where to get the requirement?

2223

how to create metric universe ?

2345

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

1052

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

1024

How to schedule the report in b.o?

1038