Query Designer - How to display the first and last date of transaction on a report?

[Former Member]

Hi all,

I am trying to provide a report using query designer. This report is based on following informations: customer, transaction date, net invoice value.

I would like to display only the first date of sales, and the last date of sales.

Did anybody do it before?

Thanks for your feedback.

Bob

[former_member182343]

Hi,

Can you provide your requirement more clearly.

If you want to know first and last transaction datas out of multiple records.

Say:

Customer  - -  doc date   - -- - amt

101  -------- 01.01.2010  - - - - 100

101  -------- 11.02.2010  - - - - 1000

101  -------- 01.11.2010  - - - - 500

101  -------- 01.02.2011  - - - - 1100

output :

Customer --- first transaction date --- last trns date --

101 -----    01.01.2010      - - ------- 01.02.2011

Then I suggest you to go with either WEBI or ABAP.

This is mostly not possible with bex. Reason is without drilldown the report output upto Doc wise level, how can we get first and last date.

With the help of Exception aggregation you will get KF value restricted with that date(either first or last) , not that date.

Customer exit even not helps you.

waiting for your replay .

_Vijay

[ravi_chandra3]

HI bob,

Have you tried with exception aggregation with reference date as date

[former_member182470]

HI,

You can achieve either by using a User Exit variable for Transaction date field in the Query or You can try to achieve by Offset Values for Transaction Date.

Regards,

Suman