Skip to Content

Comparing values from specific dates input by user

Jan 15 at 03:07 AM


avatar image
Former Member

Hello experts,

I have a problem with comparison with specific date in bex query.

The detail is below.

1. User enters two interval of dates freely, target date this year 2018/1/1-2018/1/5 and target date last year 2017/2/1-2017/2/5

2. Reports layout looks like below.

After my research, I understand that if target date last year is fixed, then I can do it with offset and 0currentmember, however, user wants to set two intervals freely.

Any experts have good idea about this ?

Best regards,


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Koen Hesters Jan 15 at 03:03 PM


you can create 2 restricted key figures, one for sales this year, with restriction:

target date this year

and one for sales last year;with restriction:

target date last year

10 |10000 characters needed characters left characters exceeded