Using Multiple What-if Parameters for product mix allocation

[Anonymous]

Hello,

I have an interesting one today.  

I have a column with 5 products.  My Table shows these products with the associated revenue and the total at the bottom. 

I am hoping to use 5 what if parameters to create a what-if product mix table.  So if I were to set each what-if parameter to 20%, the total revenue from my first table would be reallocataed in a 2nd table. 

Table 2 below is the expected result based on the parameters. I am having a hard time figuring out what the [New Revenue Measure] should be.  

Table 1			     Paramters			Table 2:	
Product	Revenue		 A	     20%		Product	New Revenue Measure
A	 100 		     B	     20%		A	    200 
B	 100 		     C	     20%		B	    200 
C	 250 		     D	     20%		C	    200 
D	 250 		     E	     20%		D	    200 
E	 300 					            E	    200 
Total	 1,000 					        Total	 1,000 

Appreciate any help!! Thank you!

[amitchandak]

Assume what if measure is a parameter and 20 is the absolute selected value
Measure = Table1[Revenue]* (1+(max(Paramters[ParamtersMeausre])/100))

[TY_223]

Hello,

What if different % are given to different products to see the revenue projection?