Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Scenario for Matching description of key figures in sap dashboard

Dear Gurus:

I have a scenario where I have to show plan and actual data of sales against each brand. I am having different queries for plan and actual data. The problem; I am having a plan of Six brands for sales A,B,C,D,E,F while we produce 5 brands A,C,D,E,F or vice versa and against these brands we have differentiation of Local and Export.e.g.

ACTUAL                                                                                                     

A          LOCAL                                                                    

A          EXPORT

B          LOCAL

B          EXPORT

C          LOCAL

C          EXPORT

D          LOCAL

D          EXPORT

E          LOCAL

E          EXPORT

F          LOCAL

F          EXPORT

PLAN

A          LOCAL

A          EXPORT

C          LOCAL

C          EXPORT

D          LOCAL

D          EXPORT

E          LOCAL

E          EXPORT

F          EXPORT

How can I have a correct figure of plan against actual figure in my table as I am using different queries for plan and actual. As I try Vlookup is not showing me correct results. Your help and suggestions appreciated.

Former Member
Former Member replied

Thanks all:


Resolved myself at IDT level, now using same query to fetch data of Actual and Plan.


Best Regards:


Jawad.K.Sheikh

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question