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

Difference between b.o 5.1 and 6.1b?

647

explain in detail about type 3?

626

Explain about a tricky situation for which you found a very simple solution?

539

What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

598

When to use local filter and when to use global filter?

599

How to create Index to the table in the universe designer and how it improves the Query performence

2115

What would you consider as your biggest achievement and why?

615

what are the tables used in health care domain project and columns used in report?

4035

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

1815

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

599

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

1432

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