4 Replies Latest reply on Aug 12, 2016 2:35 AM by ravi.chaliki

    Apply color sets to TWO dimensions

    ravi.chaliki

      Hi Gurus,

       

      I have a small query on how to use Color sets to distinguish sets of data. I have some resourcing data for 1 year which has Employees vs Contractors and Actuals vs Forecast for all months. I would like to visualize as below:

      Where Jan-Jul depict Actuals (in blue) and Aug-Dec relates to Forecast info. The top line is just a total of the total Forecast number.

       

      I am able to achieve the following: I am able to hide the forecast info for Jan-Jul, though unable to color them separately.

       

      Can you suggest a way to do the color segregation as well as add the Top line mark to display the total Forecast Number.

       

      I added a sample Tableau file if it helps.

       

      Thanks in advance.

       

      Cheers,

      Ravi.