Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
