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


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


      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:


      But it should look like this:


      Im looking forward to your suggestions