Dynamic top 10 Amount vs the rest in the same stacked bar chart
Hi All - I am trying to create something like below. A stacked bar chart that shows the top 10 sum value vs the rest sum value. The top 10 selection will be dynamic because there's a time period filter applied.
I tried to create a rank for each row within the selected period, then also created a new measure - Category top 10 based on the rank but it's not working because I can't drag this new field to seperate the top 10 portion from the bar chart. Any idea?