I have the first part of your question, but am finding it surprisingly difficult to retrieve the count of your Top 80%.
Here, at least, is how to filter for Top 80%:
1. Create a Running Total %:
Type RUNNING_SUM(SUM([Total])) / TOTAL(SUM([Total])) into the Calculation dialog box, then click on Default Table Calculation. We're going to set this up so the calculation knows to make the running sum order go along Brand for Sum(Total) descending.
In the Table Calculation dialog box, choose Compute using: Advanced.
In the Advanced Dialog Box, click Brand, then click the right arrow to put it in the "Addressing:" window. Under Sort, Choose "Field" and set it up to sort by the Sum of your Total metric descending. Click OK here, click OK in the Table Calculation box, and Click OK in the first Calculation dialog box.
You can see the results here. Notice that even if we don't have the Total column sorted descending, the Total Running % column still calculates correctly.
Now, we'll create a filter. Set this up exactly the same way as Total Running %, but add " < 0.81" on the end. This will create a True|False result. Remember to set up the Default Table Calculations the same as before.
I'll double-click to add this to the table, color shelf, and as a filter.
You would think that counting the number of items in the "True" bucket would be simple, but because the True bucket is created with a Table Calculation, it's not really a dimension. I would normally just count where that field = true, or maybe find the SIZE() of that table pane, but even the table calculations (Window_cnt, size) don't seem to recognize the difference between this field's true and false results.
I hope someone else can chime in to solve this part of your request.
Book1.twbx 31.1 KB
Thank you both, this has been helpful.
Taking it one step further - if I wanted to have the count (7) and only that to be its own sheet (to place as a floating object on a dashboard) would that be possible?
That looks like what I need, yes! But I can't open the file you just posted (but could the prior one) - perhaps a versioning issue?
If you could post a different twbx version or even the formula for the "Last" calculated field I'd really appreciate it!