Scenario for Matching description of key figures in sap dashboard
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.
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.
Resolved myself at IDT level, now using same query to fetch data of Actual and Plan.