Comments
-
Success. Thank you Mark for the direction. Here is the Beast Mode I settled on, identifying those companies in the Top-10% ... ((CASE WHEN -- running total (sorted descending) divided by series total is less then or equal to 0.1 (10%) SUM(SUM(`revenue`)) OVER (ORDER BY SUM(`revenue`) DESC) / SUM(SUM(`revenue`)) OVER() <=…
-
Thank you Mark. I'll request that extra capability now and start exploring this approach.
