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.
Hi Sundeep,
Please see the attached sample workbook which leverages the lookup function to perform the calculation.
Regards,
Crystal