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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!