Creating another row or 2 based on a calulation

[peanut89]

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 

[Christina_H]

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.

[peanut89]

i dont understand..

[BRRLL99]

Please provide sample data, with ur expected output

[Christina_H]

Something like this:

[peanut89]

Thank you so so much!