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

YTD - Please Help

Hello BI Gurus,

I'm updating the BI Content Query 0PUR_C01_Q0018 (Variances, goods receipt)where I'm filtering by <b>Material Group down </b> and <b>Calendar Year/Month Across</b> for each vendor and I would like to know how to create a <b>YTD</b> column <i>(last column)</i> that sums up the variances for each vendor for all the months.

Thanx in advance

Best Regards,

Osman

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 26, 2007 at 10:36 PM

    Hi,

    I dont thing it will allow you to change the standard query contnet.But you can copy the query and change it.

    Go to the key figurethat you want YTD for ,rt clik to go to Edit option .

    Drag 0FISCYEAR with variable 0P_FYEAR and 0FISCPER3(Posting period) with variable 0P_PER3

    Create a new selection for YTD for that KF , here again use the same key figure with the same Key figure and drag 0P_FYEAR and then drag the Posting Period 0FISCPER3 ,

    Select the options of Value range where you select the start of range as Janaury and end of range as the variable 0P_PER3 varaible.

    This should give you YTD for that key figure

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Roberto,

      Thanks for clarifying that for me. I'll post back after I get ABAP help to filter out Fiscal Year && Posting Period from Fiscal Year/Period and have tried your solution. God willing it'll work and then i'll close the thread.

      Thanks again

      Best Regards,

      Osman

      Message was edited by:

      Osman Baig

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.