Summarise top n hours within a period

[ausswe]

Hi,
I have used the following formula to summarise the top 100 of total number of hours recorded within a period:

SUM(LARGE(FILTER(Data[HOURS];Data[PERIOD]=[@PERIOD]);SEQUENCE(100)))

In a seperate column I have a COST associated with said hours and I'm trying to figure out how I can get the total COST for the top 100 HOURS recorded in a PERIOD.

I have tried this formula but I get an #N/A error:

=SUM(FILTER(Data[COST]; (Data[PERIOD] = [@PERIOD]) * (Data[HOURS] >= LARGE(FILTER(Data[HOURS]; Data[PERIOD] = [@PERIOD]); SEQUENCE(100)))))

Can anyone shed any light on this?

Thanks in advance!

 

[Fluff]

Maybe

=SUM(FILTER(Data[COST]; (Data[PERIOD] = [@PERIOD]) * (Data[HOURS] >= LARGE(FILTER(Data[HOURS]; Data[PERIOD] = [@PERIOD]); 100))))

 

[ausswe]

Spot on Fluff - thank you!

 

[Fluff]

You're welcome & thanks for the feedback.