Skip to Content
0
Former Member
Apr 27, 2012 at 06:05 AM

How to display the latest status data in BEx reporting

100 Views

Dear Gurus,

We have a scenario where data is stored in the following format.

TicketNumber Status Date

T1 submitted 01.01.2011

T1 pending 01.01.2011

T1 Recuritment 10.01.2011

T1 Rejected 11.01.2011

T1 Recuritment 15.01.2011

T1 closed 16.01.2011

T2 Submitted 01.01.2011

T2 PENDING 02.01.2011

T2 Recuriment 05.01.2011

T2 Closed 10.01.2011

Now user want to know for any month how many Tickets are in Recuritment status. Now with the current reportin in BEx i am able to get this output but Ticket T1 is being counted twice as there are two Recuriment status.

User wants to see the latest Recuritment status data only. So for T1 they only want to see 15.01.2011 status.

How can i restrict the report which will display the latest RECURITMENT status data?

Need your input on the same.

Thanks & Regards,

Anup