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

BI Query - How to move Result values to a different column

Hi Experts,

I'm looking for a way of moving values of the Result row to a separate column instead.

Change the report from how it looks in its original form (in the Left Screenshot), to my target layout (right screenshot).

Thank you.

layout.png (16.0 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2014 at 12:23 PM

    Hello Experts, thank you for all your suggestions!

    I was able to do what I need earlier, I found this article.

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70dcd7b5-6a3d-2d10-c984-e835e37071a2?QuickLink=index&overridelayout=true

    I created a new selection column and used "Constant Selection" config for the characteristic Product, so now I always see the Result next to the Return Column even if we add more Characteristics. 😊

    I will also try ANSHU's suggestion, it is always good to have more options in doing things 😊


    Re: BI Query - How to move Result values to a different column
    Re: BI Query - How to move Result values to a different column

    Anshu Lilhori Emerald

    Anshu Lilhori Jan 10, 2014 5:39 AM (in response to Juan Khushwant)

    HI,

    Make Use of SUMCT function..

    Create a new formula like this SUMCT(Return).

    This will populate the result value against each cell.Make sure to let the Result row switched on,because these functions only work if the result row is not suppressed.

    Also i would suggest to check this help.sap link for more details on the above function.

    Data Functions (SAP Library - Business Intelligence)

    Hope this is what you are looking for.

    Regards,

    AL

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 10, 2014 at 04:39 AM

    HI,

    Make Use of SUMCT function..

    Create a new formula like this SUMCT(Return).

    This will populate the result value against each cell.Make sure to let the Result row switched on,because these functions only work if the result row is not suppressed.

    Also i would suggest to check this help.sap link for more details on the above function.

    Data Functions (SAP Library - Business Intelligence)

    Hope this is what you are looking for.

    Regards,

    AL

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 10, 2014 at 09:03 AM

    HI Juan,

    I am agree with AL

    you can create formula in column which consist of data function sumct and your keyfigure it will give you sum value for each record.

    try this.

    Regards,

    Ganesh Bothe

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 10, 2014 at 03:37 AM

    Hi Juan,

    Try this one If your using product under rows panel in query designer use under column panel and run the report.

    Thanks,

    KV.

    Add a comment
    10|10000 characters needed characters exceeded

    • Kodanda,

      If Juan moves the Product characteristic to the columns, do you not think the format is going to change completely? Won't each product appear in a column on it's own. If you try to replicate yuor solution on your own system you will see what will happen and it will not gve Juan what he requested. 😠

      Juan - you can also create a new selection with the characteristic Product marked as a Constant along with the key figure.

      Regards

      Gill

  • Posted on Jan 09, 2014 at 09:25 PM

    Hi Juan,

    copy your original column, go to the properties and have a lock at the possibilities under "show single values as". I am pretty sure there should be also a summation possibility.

    regards

    Cornelia

    Add a comment
    10|10000 characters needed characters exceeded

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.