7 Replies Latest reply on Sep 12, 2017 7:23 AM by Shinichiro Murakami

# What if analysis for multiple variables

Hello everyone,

This question may sound repetitive but i am read the posts and tried some workarounds but I have not been able to crack this. So i know what if analysis for a single variable is easy like what would be by trend of my profit look like if I increase it by say 10%,20% etc.

I am trying to do an analysis involving multiple variables keeping one fixed at a time. Say if I give a 10% additional discount, how will it impact ,my sales, profit . Or if i increase the quantity of goods sold by 10%, what would be the impact on Sales and Profit. Similar if I increase my sales by x% what impact it might have on my Profits and quality sold.

I am not fully sure if it what if analysis or a correlation analysis. But i searched and couldn't find a solution. I would really appreciate any help on this.

Thank much,

Shikha

• ###### 1. Re: What if analysis for multiple variables

Hello Shikha,

I suggest you have a look at the "What If Forecast" worksheet in superstore sample workbook.

It will give you some hints.

Regards.

• ###### 2. Re: What if analysis for multiple variables

Don't  know what you want to accomplish exactly, but I created some sample.

[Simulated Profit]

([Price]*(100-[Discount %])/100-[Cost per Product])*([Qty]*(100+[Qty Increase %])/100)

[Simulated Sales]

[Price]*(100-[Discount %])/100*([Qty]*(100+[Qty Increase %])/100)

[Required Qty to meet Sales TGT (Avg)]

{fixed:sum([Sales])}*(100+[Sales TGT % increase])/100/{fixed:sum([Sales])}*[Qty]

Thanks,

Shin

• ###### 3. Re: What if analysis for multiple variables

Thanks Shin, it worked:)

• ###### 4. Re: What if analysis for multiple variables

How about if i want to have the current scenario as default and  later can input my parameter?

Is it possible to have the current scenario as default?

• ###### 5. Re: What if analysis for multiple variables

If you use Tableau server, you can set default value as parameter's "current value",and publish that file to server.

Then, user can change the parameter as they like on the web view, and "revert" button will bring the parameter back to "current value".

Thanks,

Shin

• ###### 6. Re: What if analysis for multiple variables

No I mean lets say current Profit% based on Data is 12% then my Parameter of What if Profit% should  reflect current Profit% then user can input based on his preference.

• ###### 7. Re: What if analysis for multiple variables

Nirajan,

I'm sorry I don't understand your request very well.