cancel
Showing results for 
Search instead for 
Did you mean: 

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

0 Kudos

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!

Accepted Solutions (0)

Answers (1)

Answers (1)

pierre_bournaveas
Participant
0 Kudos

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