How to derive the two column values in a single row in SAP BI BEx report

[Vijay4]

Hi Experts,

I have requirement to create BEx query as below, please help me on this.

Current report:

Notification | Local date | System date | Total

01111 28/03/2017 27/03/2017 2

Desired/required report:

Notification | Date | Total

01111 28/03/2017 2

27/03/2017

Both local and system dates should be in a single column for the notification.

Regards,

Vijay

[Loed]

Hi,

What should be the total value under the SYSTEM DATE? I think you can do this in transformation level.

Regards,

Loed

[Vijay4]

Hi Experts,

I have requirement to create BEx query as below, please help me on this.

Current report:

Notification | Local date | System date | Total

01111 28/03/2017 27/03/2017 2

Desired/required report:

Notification | Date | Total

01111 28/03/2017 2

27/03/2017

Both local and system dates should be in a single column for the notification.

Regards,

Vijay

[kohesco]

HI,

is the requirement to show only the max date?

grtz

Koen