2 Replies Latest reply on Jan 18, 2018 1:50 AM by Emma May

    Separate Colours for different parts of a calculation

    Emma May

      Hi,

       

      I have a database which holds 2 separate savings fields: they are Cashable Savings & Cost Avoidance Savings.

       

      I want to show the total savings (i.e. Cashable + Cost Avoidance) but highlighting each in a separate colour either as a stacked bar or a pie chart.

       

      My table looks like this

       

      Header 1
      FY 15/16
      FY 16/17FY 17/18
      Cashable100,00081,273.40200,000
      Cost Avoidance150,000529,258.26100,000

       

      & this is what I want to do

       

       

      I haven't got a specific tableau report for this as it is part of an greater dashboard

       

      Kind Regards

      Emma