Duplicate the plate measure and rename it like plate%.
Bring the duplicated measure into the view, Right Click->Quick table calculation-> Percent of total.
Now bring the measure also in text now you will get the exact distribution
Create calculated field -> SUM(Plate)/TOTAL(SUM(Plate))
Set default properties for this calculation as Percentage and bring this into the view
I have tried both of these, and they do not provide the necessary results.
So this seems to work to an extent. Can you think of a way to apply this to only look at the rows displayed in the worksheet? I am leveraging Index() <= 10 to limit it to the top 10.
You may try this,
Top 10: INDEX()<=10
While using INDEX you need to set up the table calculation like above screenshot
You can also use RANK() like this: RANK(SUM([% of Total]),'desc')<=10
Just drag it to filter shelf and select "True", compute using table down.
Hope this will help.
Sample_v10.2.twbx 29.1 KB