There are 2 tables (Table 1 and table 2). the image you see is table 2. and will always be a constant.
So if application area is 'building automation' in both table 1 and table 2 . and revenue in table 1 is 100.00 usd
Another 2 rows need to be generated.
row 1: segment Lv 2#1 = smart building & {segment % #1 } *revenue = 60
row 2: segment #2 = home locks & {segment % #2 } *revenue = 40
Hope im making some sense.
Your help is appreciated
This looks like you need to transpose table 2 to get the segments on separate rows (might take some fiddling to get the layout correct, but since it's a fixed table you could also do it manually), then joining to table 1 on Application Area will result in two rows. A formula tool is the last step to get the correct revenue figures.
i dont understand..
Please provide sample data, with ur expected output
Thank you so so much!