I want to create a summary result for a column, Loan_Amount.
Let’s say I have 6 months of data for Loan_Amount for year 2011 which is given below:
Now, when I will cut the report on Year or Quarter, I sould get the following result:
Q1 2011 25,000
Q2 2011 60,000
I have achieved the above in OBIEE11g by just applying LAST function to Loan_Amount in the Admin Tool.
How do I implement this in Cognos 10.2 ?
Any suggestions/ideas will be highly appreciated.
Thanks n Regards