Hi Team,
I have a requirement as below. From first three tabs , i took the data to the fourth tab.
From first three tabs there is no value stream , so i applied applymap and got the valuestream to the main mapping file.
my code is as below:
output i am getting like this, but i am not getting ValuestreamCost% and ValuestreamFTE% for the Area functions. It should come as 100% in both the values. i applied applymap for both the fields but it is not coming.
Output |
|
|
|
|
|
|
Level 5 |
Area |
Value Stream |
ValuestreamCost% |
ValuestreamFTE% |
% cost |
% FTE |
A |
ABC |
Toys |
47% |
47% |
100% |
100% |
A |
DEF |
Toys |
53% |
53% |
100% |
100% |
A |
Functions |
Toys |
- |
- |
100% |
100% |
I have one excel file which has four tabs. snippets are below:
First Tab
2nd Tab:
3rd Tab:
4th tab:
Please help me on this