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.