I am trying to group by three fields, year, week and type however, I have had to manipulate the original type field to group two of them under the same category. As per the attached image, I would hope to have the data sorted in the table by year (2022), week (27) and Battery =5 and Solar =23 as opposed to having them split out.
Thanks in advance!
