Skip to Content
author's profile photo Former Member
0
Former Member

Calculating receipts from previous month based on the sales of current mont

Posted on Nov 20, 2011 at 04:31 AM 10 Views

Hi Gurus,

I have a requirement where i need to display sales for a quarter and need to display receipts from the previous quarter. For example consider that i am displaying sales from week1-Aug to Week4-October, I need to display receipts ( R_Net_RCPTS) from Week1-july to Week4-September. In that way If i select Wk1-Aug for sales it should display Wk1-july receipts. i need to do this in Webi by creating appropriate variables.

I have got prompts on year and Fiscal Week

I have given year as 2011 and The "08: Fiscal Week From:" as "Wk1-Aug" to "08: Fiscal Week To:" as "Wk4-Oct"

I HAVE GONE THROUGH ALMOST ALL RELATED THREADS, BUT COULDN'T FIND ANY SOLUTION. ITS REALLY URGENT. PLEASE HELP ME AND I WILL FOR SURE GIFT POINTS.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2011 at 06:16 AM
    1

    hi,

    We have to create 2 queries,first for the date range of sales and date range of reciepts .

    We can make two coloums as receipts and sales from 2 quieres we have merge the dimensions of 2 queries.

    Hope it may help u.

    Regards

    suresh kumar.p

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2011 at 08:11 AM
    0

    HI

    Your explanation is not clear whether u want to display current quarter data or you would like to see only previous month data ?

    Which dimension you are taking for week ? how data would be like ?

    Edited by: K.sunil on Nov 21, 2011 9:14 AM

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Nov 21, 2011 at 07:33 PM

      Thanks for responding. I want to display sales from the months July, August and september. And have to display receipts from the months June, July and August ( i.e. one month previous to the current quarter sales) .... I have got fiscal week as the dimension, there is no month in the databse. Just let me know if this information is clear

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.