6 Replies Latest reply: Aug 11, 2011 11:06 AM by myid24784 RSS

    Pivot Table - Layout Problem

      Most of my questions were resolved quickly by the search function.

      This Time, i could not find an answer.

      So here is my Problem: I want to compare Temparatures in identical buildings in the same area.

      "Location" is simply a sensor in an "area"

       

      The Data is imported from excel files like this

      table_1.jpg

      to preven having attributes like Location_1, Location_2 etc. the Data is transformed (by using crosstable) to:

      table_2.jpg

      I have loaded the current tables for building A and B. (Date, Location, Temperature(A or B))

      Now i want to display the data of building A and building B in a pivot table

       

      at the moment, it looks like this:

      table_3_pivot_SOLL.jpg

      But it should look like this:

      table_3_pivot_SOLL.jpg

      Im looking forward to your suggestions