This content has been marked as final. Show 6 replies
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