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