Good Afternoon All,

I currently have two pivot tables, one has solar energy production data for a day split in hours, i.e., “Monday, 7/01/2024 – 12:00am – 1:00am” and the other has electricity usage data for a day split in 15 minute increments, i.e., “2024-07-01 00:00:00 to 2024-07-01 00:15:00”, “2024-07-01 00:15:00 to 2024-07-01 00:30:00”, and so on and so fourth. 

I am trying to group the pivot table that is split in 15 minute increments by every 4 rows to match the solar energy production data for one hour increments but I am having trouble working the pivot table to group automatically.

I tried creating a calculated field using the following formula but had no luck: 

SUM(OFFSET(“STARTING ROW”,(ROW()-ROW(“COLUMN START”))*4,0,4,1))

Is there an easier way to compute this so when I update the data it is automatically group by every 4 rows? It is a bunch of data (goes from 0000 to 2345 in 15 minutes) so grouping manually is not ideal. 

Please see the attached picture for reference and I can provide the excel sheet if needed.

Thank you!

Marshall

​Good Afternoon All, I currently have two pivot tables, one has solar energy production data for a day split in hours, i.e., “Monday, 7/01/2024 – 12:00am – 1:00am” and the other has electricity usage data for a day split in 15 minute increments, i.e., “2024-07-01 00:00:00 to 2024-07-01 00:15:00”, “2024-07-01 00:15:00 to 2024-07-01 00:30:00”, and so on and so fourth.  I am trying to group the pivot table that is split in 15 minute increments by every 4 rows to match the solar energy production data for one hour increments but I am having trouble working the pivot table to group automatically. I tried creating a calculated field using the following formula but had no luck:  SUM(OFFSET(“STARTING ROW”,(ROW()-ROW(“COLUMN START”))*4,0,4,1)) Is there an easier way to compute this so when I update the data it is automatically group by every 4 rows? It is a bunch of data (goes from 0000 to 2345 in 15 minutes) so grouping manually is not ideal.  Please see the attached picture for reference and I can provide the excel sheet if needed. Thank you! Marshall  Read More

​