Data: Hourly Pricing 1-24 since April 2009 *Sample Shown Below*)
Current Pivot Table
The pivot table's Row Labels go by "Year"-> "Month"-> "Day" and I want it to go "Year"-> "Month"-> "Day"-> "Hour"
Below is a link to another thread where I was trying to achieve the above goal by transposing the hourly data but I received no response to this so I am assuming it is too difficult.
http://www.mrexcel.com/forum/showthread.php?mode=hybrid&t=503003
Ultimately I want to have my Row Labels "Year"-> "Month"-> "Day"-> "Hour", my Report Filter "Day of Week" -> "Hour of Day" and then i just want the Data Values to display the averages of the specified information.
If I am not being clear ask any questions so I can elaborate.
This is going to be a very important part of a research project I am doing for school so any responses would be appreciated.

Current Pivot Table

The pivot table's Row Labels go by "Year"-> "Month"-> "Day" and I want it to go "Year"-> "Month"-> "Day"-> "Hour"
Below is a link to another thread where I was trying to achieve the above goal by transposing the hourly data but I received no response to this so I am assuming it is too difficult.
http://www.mrexcel.com/forum/showthread.php?mode=hybrid&t=503003
Ultimately I want to have my Row Labels "Year"-> "Month"-> "Day"-> "Hour", my Report Filter "Day of Week" -> "Hour of Day" and then i just want the Data Values to display the averages of the specified information.
If I am not being clear ask any questions so I can elaborate.
This is going to be a very important part of a research project I am doing for school so any responses would be appreciated.