3 Replies Latest reply on Dec 5, 2013 8:14 PM by Jen Vaughan

    Creating a dimension indicating which table a metric is from

    Allison Brown

      I have one table that is "forecast" and one that is "actual." It is the same data, only one has actual sales, while one is forecasted. I joined them based on item number.

       

      When I pull in the metrics "forecasted sales" and "actual sales" into a bar chart, I have no way to control color indication between forecast and actual.

       

      I'm wondering if there is a formula that I can write, something like IF <metric> is from table_forecasted THEN "grey" ELSEIF <metric> is from table_actual THEN "red"

       

      Or any other suggestion would be appreciated!