12 Replies Latest reply on Aug 16, 2018 1:00 PM by Joe Oppelt

    Calculation help

    fugita.nasseri

      Hello,

      looking for help to figure out a problem i am having in Tableau.  I am trying to create a table showing a breakdown of total group area by group name.  In this example, i would like to show how much square footage is allocated to Dept 1 and Dept 2.  Because the data set contains multiple duplicate rows of data, i am not able to get an accurate area calculation for each group.  Room 638 should total 117.72 and room 642 should total 130.87.  Is there a way to create a calculation that omits the duplicate rows?  This is a small data set in excel as an example.

       

       

      Thanks.