1 Reply Latest reply on Nov 29, 2017 5:30 PM by Crystal Meyers

# Total volume by months and want to dynamically calculate (as per user input selection) what percent of volume will be cleared and in what months

Hello Tableau Gurus,

I have total volume by months now i want to dynamically calculate (as per user input selection) what percent of volume will be cleared and in what months. so i know ideal solution will be to create parameters

Parameter 1 :- First Month Selection

Parameter 2 :- Second Month Selection

Parameter 3 :- Third Month Selection

Parameter 4 :- Percentage Clearance

Parameter 5 :- Percentage Clearance

Parameter 6 :- Percentage Clearance (Mostly this wont be required as total should be 100% so it will be parameter 4+5 - 100%)

So if user selects

Parameter 1 :- 3

Parameter 2 :- 6

Parameter 3 :- 9

Parameter 4 :- 40%

Parameter 5 :- 30%

Parameter 6 :- 30%

Then the total clearance values should be calculated accordingly. like 40% volume will be cleared after 3 months and so forth.

 Months Total Volume % Volume Cleared as per Parameter 1 % Volume Cleared as per Parameter 2 % Volume Cleared as per Parameter 3 30/11/2017 1000 31/12/2017 1200 31/01/2018 1400 28/02/2018 1600 400 31/03/2018 1800 480 30/04/2018 2000 560 31/05/2018 2200 640 300 30/06/2018 2400 720 360 31/07/2018 2600 800 420 31/08/2018 2800 880 480 300 30/09/2018 3000 960 540 360 31/10/2018 3200 1040 600 420 30/11/2018 3400 1120 660 480 31/12/2018 3600 1200 720 540 31/01/2019 3800 1280 780 600

A sample solution in tableau workbook 10.1 will be appreciated.

• ###### 1. Re: Total volume by months and want to dynamically calculate (as per user input selection) what percent of volume will be cleared and in what months

Hi Sundeep,

Please see the attached sample workbook which leverages the lookup function to perform the calculation.

Regards,

Crystal