2 Replies Latest reply on Nov 14, 2016 1:43 PM by D Barnetson

    Turn Row into Column for Breakdown in Bar Chart

    Matt Fischer

      Hello all,

       

      I am looking to break out a customer's bill into sections, base plan, minutes, additional minutes, additional phone charges, and taxes+fees. However, the underlying data includes "taxes" in each section (base plan is base plan + taxes, minutes is minutes + taxes, etc etc.) How can I break Taxes out to be another series?

       

      This is what I currently have:

       

      IDDate
      Charge Type
      Base Amount
      Tax Amount
      Total Charge
      19-1-2016Base Plan10.310.3
      29-1-2016Minutes1.11.1
      39-4-2016Additional Minutes451.246.2
      49-4-2016Additional Phone Charges51.26.2

       

       

      But I would like Tableau to interpret it like this:

      IDDate
      Charge Type
      Base Amount
      19-1-2016Base Plan10
      19-1-2016Taxes.3
      29-1-2016Minutes1
      29-1-2016Taxes.1
      39-4-2016Additional Minutes45
      39-4-2016Taxes1.2
      49-4-2016Additional Phone Charges5
      49-4-2016Taxes1.2

       

       

      Workbook is attached, thank you!