Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Change Rank(Sum(Sales)) to Rank(-Sum(Sales)) for the bottom ranks.
Change Rank(Sum(Sales)) to Rank(-Sum(Sales)) for the bottom ranks.
Thanks Mr. Gysbert