MaxOver Top 10 filter within Calculated Field

I’m working within narratives and want to take the Top 10 and divide that by the total to see how much the top 10 is contributing to the overall delta.

For example, if the overall delta is $100, and the Top 10 (of a sample size of say 25) make up $60, then would want the narrative to say “Of the $100 total opportunity, the Top 10 make up 60% of it” but I’m having a problem with getting the Top 10 summed up within a calculated field since I can’t apply a filter to the viz since it’d filter out the whole opportunity as well

Can you create a calculated field that takes a sumOver with a PRE_FILTER aggregation?

Prefilter calculations are computed before the dataset filters.

Hi @Clayton_Barton

Hope Max response was helpful and able to resolve issue ?
If yes, would request you to mark the post as “Solution”.
This will help the community to find guidance and answers to similar question.

Thank you!