3 Replies Latest reply on Oct 22, 2013 8:04 AM by Matt Lutton

    master detail total problem

    Ertan ERISIK

      Hi,

       

      I am trying to build a workbook having two tables in master detail relation. The master table contains date of election, province and no of reps  and the detail has date,province,city and number of votes. When I would like to show number of reps for each party, I get duplicated sum of number of reps due to the one to many relationship. I set up the connection between master detail using three columns date,province and party. Is there any way to show no of reps without duplicating?

       

      you can find the attached workbook with sample data.

       

      Thanks a lot for the help in advance.