Skip to Content
avatar image
Former Member

Comparing values from specific dates input by user

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,

Chang

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 15 at 03:03 PM

    Hi,

    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

    Add comment
    10|10000 characters needed characters exceeded