Calculate percent coverage of rows in straight table

[#1]

Hi all,

I have a requirement where I need to show Top10 Field1 and then show the coverage percent that the Top10 represents relative to the total, ie, imagining the Dimension Limits tab where we can choose to Show Only Values that accumulate to x% relative to the total - in this case I need to figure out what that percentage is.

I've made the Top10 by building a Straight table, forcing its sort order and then simply limiting the number of items presented (in the Presentation tab), so I used no Dimension Limits.

The percent coverage is supposed to be shown in a text box or even table caption.

I've been browsing through F1 as well a the community and I was thinking about using aggr and rank but I still haven't found the right way to do this - do you have any ideias on this?

Thank you very much,

Marina C.

[#2]

Hi orsh_,

Thank you so much, it does work perfectly!

You were also correct about being able to do it a bit simpler, as Joseph as shown below but I've tried both ways and both work.

Thank you again,

Best Regards,

Marina