2 Pivot tables, error one column aggregates the vlues

  • Hi,


    I am trying to combine two pivot tables. I cleaned all duplicates and I am using as relationship the date (dd-mm-yy hh-mm). My problem is that when I try to make a new pivot table with one field from each table it sums up one of the fields. I try to explain better. I have one pivot table with date1 and measurement1 columns and another one with date2 and measurement2. When I make the combined pivot table with i.e. date1, measurement1 and measurement2 columns, measurement2 columns gives the same value for all rows (the total sum of measurement2 column) . If I make the combined pivot table with date2, measurement2 and measurement1, then measurement1 gives the same value for all rows (the total sum of measurement1 column). thanks.



    German