on 09-16-2014 9:42 AM
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.
Thanks all:
Resolved myself at IDT level, now using same query to fetch data of Actual and Plan.
Best Regards:
Jawad.K.Sheikh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jawad, Its can be easily by using webi report.After that you can consume this data in SAP Dashboards. You you are interested in this approach , Then I will explain in detail.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi !
If the sales are only for 6 brands you can do by reference cells. further i would like to connect via TeamViewer if u agree.
Thanks
Yash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
a | b | c | d | e | f | g | h | i | j | k | l | m | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | plan | actual | Using | Reference | |||||||||
2 | sale1 | local | 100 | sale1 | local | 15 | local | Plan | Actual | ||||
3 | sale1 | export | 50 | sale1 | export | 50 | sale1 | =c2 | =f2 | ||||
4 | sale2 | local | 50 | sale3 | local | 20 | sale2 | =c4 | |||||
5 | sale2 | export | 100 | sale3 | export | 30 | sale3 | =c6 | =f4 | ||||
6 | sale3 | local | 50 | ||||||||||
7 | sale3 | export | 100 |
Similarly you can make a same table for Export.
this may work you have to get the data exactly in excel. for this you may use comboboxes at backend with default label such as local and export and that may give correct columns for you to map.
if this varies according to month then you can use vlookup after using combobox.
Thanks & Regards,
Yash
What is your source ? if its BW then you can create a multi-provider on top of this data marts which provide this query and then you can create a single bex query on this (or) take both the query's to webi report and do the merge dimensions to the A,B,C,D,E,F and then create a single report for the dashboard.
Though you may have a possibility in doing this using excel formula, i can't guarantee how much dynamic this would be, i would suggest you to go by the above steps.
Hope this helps!!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.