Dynamic Top N & Others Beast Mode
Hello everyone! I am trying to build a table that dynamically shows the total for the TOP 10, Others (excluding the TOP 10) and the TOTAL (considering both). Currently i have this beast mode to pick up the sales for the Current Year SUM( CASE WHEN Calendar Year = 2025 THEN Sum Net Sales ELSE 0 END ) And this beast mode to…
