1 Reply Latest reply on Mar 1, 2016 9:06 AM by patrick.byrne.0

# Product price relationships

I am trying to establish a relationship between two products.  I have a model built to determine new sell prices, but want to build another calculation to ensure two products always maintain a certain relationship.  For example product A shows a sell price of \$10 and prodcut B shows a sell price of \$8.  If i want the relationship to always be product A is \$1 more expensive than product B (B is the driver), how would i accomplish this?  There are 50 products but only a few need relationships.

Sell price is an aggregated calcuation based on other data points and calculations in the data set.

Any help would be appreciated.

JP

• ###### 1. Re: Product price relationships

John,

I believe that what is trying to be accomplished is there is two columns of aggregated data, where specific values have a relationship that must be maintained. I would suggest that you could utilize a Logical Function found here  http://onlinehelp.tableau.com/current/pro/online/windows/en-us/help.html#functions_functions_logical.html?Highlight=func… . Utilize a case or if statement to add the specified amount to the correct rows of data. I have also attached a sample workbook that can be utilized to develop a solution. Take a note of how the calculated field [New Amount] is creating the corrected price for [No]=1 and how [No]=2 just shows the same price as in [Amount].

Please let me know if something is unclear or if additional questions arrive?

-Regards,

Patrick