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

how to get this report

Sales Document Date Value Curr OUT PUT Sales Document 2010 value in USD 2012 value IN USD 2014 value IN USD 501000000 1/5/2010 1549 USD 501000000 501000000 12/12/2012 1250 USD 501000001 501000000 9/11/2014 1233 USD 501000002 501000001 1/6/2010 1200 USD 501000003 501000001 12/6/2012 1100 USD 501000004 501000001 8/1/2014 1309 USD 501000005 501000002 11/5/2010 1980 USD 501000002 19/6/2012 1675 USD 501000002 23/12/2014 789 AED 501000003 1/5/2010 896 AED 501000003 21/6/2012 120 AED 501000003 6/6/2014 755 AED Fill the green coulmns 501000004 19/5/2010 1230 USD 501000004 17/6/2012 900 USD AED - AED United Arab Emirates Dirham 501000004 8/1/2014 1500 USD USD - US dollars 501000005 25/10/2010 1100 USD INR - indian rupee 501000005 12/8/2012 130900 INR 501000005 22/12/2014 143000 INR Source

result what i got

Sales Document 2010 values in USD 2012 values in USD 2014 values in USD 501000000 1549 501000000 1250 501000000 1233 501000001 1200 501000001 1100 501000001 1309 501000002 1980 501000002 1675 501000002 2895.63 501000003 3288.32 501000003 440.4 501000003 2770.85 501000004 1230 501000004 900 501000004 1500 501000005 1100 501000005 7854000 501000005 8580000

.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Jul 21, 2014 at 10:39 PM

    Hi,

    What is your requirement?. Post more details pls.

    Thanks,

    Jothi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 22, 2014 at 02:19 AM

    Hi Prithvi,

    What I understand from your requirement is you want to do currency conversion from AED/INR to USD and want to display data in crosstab.

    Currency conversion is not recommended to do at Webi report. I will recommend to do conversion at data mart level and then create Webi report.

    Please see below thread for more detail-

    ~Anuj

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 22, 2014 at 03:00 AM

    thank u anuj for your valuable information

    output what i required in this format

    OUT PUT Sales Document 2010 value in USD 2012 value IN USD 2014 value IN USD 501000000 501000001 501000002 501000003 501000004 501000005
    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      You only need to create one variable to get year.

      Place Year in the Crosstab row and sales document in the column. Put value below column to year and cross tab will split the values according to years.

      After that if you want to show "values in usd" after year then add + " Value in USD" after year variable.

      See attached screenshot for reference.


      If you are facing some issues then share the screenshot.

      Regards,

      Amit

      Cross tab.JPG (28.8 kB)

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.