2 Replies Latest reply on Feb 5, 2013 8:58 AM by Jonathan Drummey

    table calc will not work with blended data?

    .Yann Treguier

      I have a calculated field that computes a ratio using two data sources that are blended (SUM(souceA.total)/ SUM(sourceb.total).  That calculated field is graphed on a bar chart which has a field from the main data source on the color shelf.  It displays the measure accurately within each color segment.  I wanted to put a table calc on top of it to display each color segment as a % of the bar.  It won't work.  The error is "the input to TOTAL() must be from a single data source".

       

      Is there a workaround that I could use?