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

    sundeep chokshi

      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.

       

           

      MonthsTotal Volume% Volume Cleared as per Parameter 1% Volume Cleared as per Parameter 2% Volume Cleared as per Parameter 3
      30/11/20171000
      31/12/20171200
      31/01/20181400
      28/02/20181600400
      31/03/20181800480
      30/04/20182000560
      31/05/20182200640300
      30/06/20182400720360
      31/07/20182600800420
      31/08/20182800880480300
      30/09/20183000960540360
      31/10/201832001040600420
      30/11/201834001120660480
      31/12/201836001200720540
      31/01/201938001280780

      600

      A sample solution in tableau workbook 10.1 will be appreciated.