Skip to Content

Is there a way to roll up/consolidate matching data based on a column?

Hello,

Please refer to the following image as I am not fully familiar with BI technical terms: https://imgur.com/a/J6pViat

If you click on the link, the table on top is the current report i have built so far. I wanted to roll up 'April Goal' and 'May Goal' amount and keep the owner information with the one who has the highest owner percentage.

I wanted to ask if this is anyway possible. I am very new to creating a report so it took awhile for me to get to this point (the uploaded screenshot is a sample i created for this scenario) and this is the last requirement i am struggling with.

Any advice would be great.

(My last option is to export it as Excel and write a Macro script to do it, i want to see if i can manage it on BI side only.)

Thank you!

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Feb 04, 2019 at 09:32 AM

    Dear Edward,

    You have tagged your question with produt SAP Financial Consolidation, however I think that you are refering another product to build your reports, can you please give us more information about this product so we can redirect correctly ?

    Thank you

    Best Regards,

    Pierre

    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.