Is there any way to add custom values and formulas on this table that uses data from within BI?

[Talisman2208]

Disclosure: Super noob.

So I made this table that has the information I want, but there's some values and calculations I want done on the table that are not from within BI. 

For example, BI provides the loaded volume, but we have a target number we want to hit that I'll just type in manually, then from there the next two columns would be some calculation based on the loaded volume and target number. % of target number and Price. Sort of like I could do in excel. Otherwise I would have to export this all and do it within Excel. Is there a way to do this? 

[AliceW]

yeah, you could create calculated columns and/or measures. If you have a target for each RawProductCode, your best bet is to create a table with two columns: this code and the target.

There are some pretty cool learning paths to get you started...

[talisman2209]

It's me, I don't know why I couldn't log back into that other account, weird. 

Anyway - thanks for your reply.

My target is based on the source in column 1, I can create a table with those columns but how do I get the two tables to interact with one another?