Interested to Buy Any Domain ? << Click Here >> for more details...
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:)
- 3 Answers
- 7033 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
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
what is document design in boxi,have u participate in that
any difficulitis have you phase while creating bo reports and how did u solve it
Explain about a task that really tested your analytical abilities?
What is difference between custom hierarchy and report based hierarchy?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
what is universe null
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
When we use aggregate awareness function in designer?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
Explain the difference between detect alias and detect context?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
What is the difference between datawarehousing and businessintelligence?
How would you format some text using css to be verdana and bold?
