One option is to not use index, and instead place CorpAsso on the filter shelf. Choose the Top tab, use Top 10 by Revenue.
Hope this helps!
Thank you for the reply ☺
The only thing I have a problem with is that
as I already use date filter,
if I filter it by revenue it’s not going to be the revenue on that window but revenue total disregarding the date filter.
I have created window_sum for the revenue, but I wasn’t able to use it as filter. Where should I go from here?