Hi All,
I created 2 variables to dispaly only the top Product Number based on the Revenue.
Ranking : =Rank([Revenue];[Product Number];Top) ForEach ([Product Number])
Top 10 (In Report it's renamed as Product Number) : =[ProductNumber]Where([Ranking]<=10)
The above formulas looks good and working fine.
The issue is when I try to bring the Customer Name in the table block then the table is expanding.
I want to display only the customer Names related to Top 10 (In Report it’s renamed as Product Number). I don’t want to see the remaining ones.
RUC (BOB member since 2010-05-03)