How to get the bottom sales report by passing the parameter?

[#1]

Hi,

I have calculated the Top sales report based on passing parameter

v_Top = 10

if(Aggr(Rank(Sum(Sales)),Item)<=v_Top,Item,null()) - Dimension

Sum(Sales) - expression

So when i pass the parameter via v_Top, i could get the top item report.

But i want to create the bottom items sales report by passing parameter same like top sales report.

I would be really grateful if you advise me

Best,

Robert

[Gysbert_Wassenaar · Accepted solution]

Change Rank(Sum(Sales)) to Rank(-Sum(Sales)) for the bottom ranks.

[#3]

Thanks Mr. Gysbert