Skip to Content
avatar image
Former Member

Last week vs Current week sales logic in Webi

Hi Experts,

I came across a situation where user request to get Last week sales and current week sales in report whenever he clicks on prompts values.

I tried with various logics and tried in forums but no luck

Could anyone explain the logic behind that

Any help much appreciated

Thanks,

Varun

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Apr 05, 2016 at 05:09 PM

    Hi Varun,

    Please clarify few things:

    1. When the user tries to refresh the report, in the prompt screen he needs to see a prompt to select a period for which the LOVs will be Last Week Sales, Current Week Sales. Correct?
    2. If the user select Last Week Sales, he'll get data for the last week only in the report? Correct?

    If Yes for both the questions, you'll have to create that Filter in the Universe, try this

    CUSTOM PREDEFINED DATE RANGE FILTERS (WTD/MTD/QTD/YTD) in BO

    Check Divya's response in this discussion:

    Thanks,

    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 06, 2016 at 03:53 AM

    Hello Varun,

    What is the value that your Prompt is created for?

    Is it some Date field?

    Regards

    Niraj

    Add comment
    10|10000 characters needed characters exceeded