I am glad to write my first post here :)
I have a question: using excel, I need to compute the media for Date and Sector, as we can see from this short example that I have created:
If you do not have Excel 365, you can use
= MEDIAN(AGGREGATE(14,6, 1/((Table1[Date]=G4)*(Table1[Sector]=H4))*Table1[Value],ROW(INDEX($A:$A,1):INDEX($A:$A,SUMPRODUCT((Table1[Date]=G4)*(Table1[Sector]=H4))))))

