1 Reply Latest reply on May 25, 2016 10:39 PM by Mahfooj Khan

    Remove duplicate items in total sum

    Eitan Segal

      Hi All,

      I am developing a story that includes several levels but I would like your assistance in addressing the first one before I progress to the upper level.

      My data source is an excel file with several tabs each for a description of a system but the structure is the same .

      I need to Sum system capacity per type but i want to exculde the repeatable lines .

      Is there a simple way to address this


      The attached file contains a simple example to show case the data strucutre


      Many Thanks

        • 1. Re: Remove duplicate items in total sum
          Mahfooj Khan

          You can pivot your data in excel and copy pivot data in blank sheet then connect the file in tableau that will be more esier for your further calculations.

          In tableau without pivot it'll be like this. As per your file there are two sheets. One is "Data" and second is "Information".

          You should use blending to join with other data sources. Just like join in database. You should have some common unique fields in both the data sources. So that you can join. In tableau its called blending which is left outer join in nature. To get the desired output you've do some exercise. First find out those common columns which will be yours blending keys. Then from data menu go to to edit relations and use custom to add the joining conditions. See the screen shots. As per my understanding I've selected few columns. Don't forget to join the chain in data pane. For more information about blending you can refer below link.

          Deciding Between Joining Tables and Blending Data | Tableau Software

          Data Blending with Summarized Data | Tableau Software

          I've attached the workbook (version 9.2) for your reference. Have a look and let me know If you've any query.