I have a table that has almost 1.000 substations as columns and each substation has energy prices for every hour for each month (744 values for each substation for January, for example). My objective is to get a monthly average of those prices for each substation by filtering the month I want to check, but of course, I don't think that adding one field by one to a pivot tablewill be the best approach.
These tables look like this:
Month Substation 1 ... Substation 999 201701 35 ... 29 201701 46 ... 16 ... ... ... ... 201712 35 ... 27 201712 39 ... 100
Any suggestion or recommendation on how could I approach this problem would be awesome. Thanks!
Bookmarks