Work in Dynamic calculations

[Anonymous]

Hi,

I've attached a sample data and my requirement is to get the resultant dataset (On Right in attachment) after multiplying with Selected Multiplication value in the data. The selection value can be from  1 to 10 by user.

https://drive.google.com/file/d/1oN9VYGRbmWeUrxhiWtJXjfTKB6dpI6AW/view?usp=sharing

REgards.

[Tahreem24 · Accepted solution]

Hi @Anonymous,

I have created step by step solution for you.

Please mark my answer as a solution so that it may helpful for others.

 

[Tahreem24]

Hi @Anonymous ,

I hope I answered your doubt so please mark my effort as a solution :). It may also help others.

[Anonymous]

Thanks it works for me.

Appreciate your Help.

[Tahreem24]

Great! Good to know that defined solution worked for you.

[Tahreem24]

Hi,

I might have found the answer of your question. You can achieve this using What-if-Parameter. 

I have created sample of your data and achived the expected result in below screen shots.

User Input is 2User Input is 4