Rank a List Table with Section

[reginoilano]

Guys,

I'm having a hard time to get the Top 10 of revenue in a list table where it has section per store.

the main goal that I need to achieve is to get all the top 10 revenue per store. this report has only one query used by the list table with a section of store.

your suggestions will be much appreciated!

[MFGF]

Hi,

Define a rank column as a Query Calculation with the expression rank([Revenue] for [Store])

Add a detail filter with the expression [Rank] <= 10
set its timing to After Auto Aggregation.

MF.

[reginoilano]

Thanks MFGF! now it's working :)