I have a dataset of load data. CAISO is the total and I want to know the load shares for measures that are subsets of the data (what portion of the total are they at the time the maximum CAISO values occur? How do I do this?
Not sure what exactly the expected result you are after, I guess you want to get the data row where max CAISO happens for each month, if this is the case, please find below calculation