5 Replies Latest reply on Nov 7, 2013 1:46 PM by kettan

    How to sum distinct by identifier not shown on the visualization

    Philip Ellis

      I have searched the forums and tried doing this many different ways, but haven't found a way to make this visualization show properly. I have a data set as follows: (The real data set has thousands of identifiers but the data is essentially the same.

       

       

      IDRegionDistributorAmount RequestedAmount ReceivedGap
      1WestA269.95221783.3854998186.5667
      1WestB269.95221783.3854998186.5667
      1WestC269.95221783.3854998186.5667
      2MidwestA366.797166343.7226817323.0745
      3EastB543.082605885.06967039458.0129
      4EastA543.697742573.39220443470.3055
      5MidwestA277.894812490.08573608187.8091
      5MidwestB277.894812490.08573608187.8091
      5MidwestC277.894812490.08573608187.8091

       

       

      In Tableau, I want to show a stacked bar chart where each column is a region and two stacks are amount received and the gap (which will add up to the amount requested) as shown below, I have created this in Tableau, but there is a problem, the amount received and the gap are being double counted for each ID. I want to sum distinct on each unique ID. Below is what Tableau shows:

       

      Tableau.jpg