1 Reply Latest reply on Nov 2, 2016 10:38 PM by KJ Kim

    Waterfall Chart from two Data sources

    ravi.chaliki

      Hi Tableau Gurus,

       

      I need help to crack a requirement. I am adding sample data to reflect what I am trying to do and also attached an Excel workbook with Sample data and required output in separate worksheets.

       

      I have following 2 data tables.

      1. Previous sales total for different Products.

      ProductSales
      P1300
      P2450
      P3400
      P4250
      P5350

       

      2. Product - Quarterly sales

       

      ProductQuarterSales
      P1Q170
      P1Q210
      P1Q3-10
      P1Q480
      P2Q150
      P2Q2100
      P2Q3-30
      P2Q470
      P3Q120
      P3Q2100
      P3Q3-80
      P3Q420
      P4Q130
      P4Q210
      P4Q3-60
      P4Q430
      P5Q110
      P5Q2-50
      P5Q380
      P5Q4100

       

      I am trying to output a waterfall chart for All products put together and ability to drill down by individual Product.

       

      Any ideas on how this can be achieved? Please find the sample data in attached Excel file.

       

      Thank you,

      Ravi.