what if analysis

[Anonymous]

I have a table with recipes from a restaurant

Receipt   ingredient      Cost

A                      A1           10

A                      A2             5

A                      A3           20

B                      B1            30

B                      B2            10

B                      B3            15

I want the end user to be able to run simulations by choosing price variations between -10% and + 10% for each of the ingredients, that is, he can choose that A1 increases 10%, A2 15% and A3 5%, and see the efect on total cost, the same for the ingredients in B the user wants to simulate what happens to the total cost of product A or B , making the cost of the various ingredients vary differently and at the same time.

How can I do this in a published report

[Ahmedx]

watch this video it will help you
https://www.youtube.com/watch?v=YdBvLjo-akY&t=335s

[Anonymous]

thanks for help, but using this parameter applies the percentage change to all costs equally (the percentage change is the same for all rows in the cost column) I need to choose different percentage changes for the rows in the cost column according to the choice of % of variation chosen by the user