Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Vishwarath,
Thank you.
I should have used the actual expression that I am using. I am trying to rank based on the count. Rather than Sum(NetSales), I am using the following expression:
RANK(
Count(DISTINCT {<%Order={"=QtyOrd=QtyShip AND ShipDate<=PromiseDate"}>} OrderNumber)
/
Count(DISTINCT OrderNumber))
Any idea how to get Whse_name for this? Currently this is returning a number rank.
May be this?
= FirstSortedValue(Whse_Name, -Aggr(Count(DISTINCT {<%Order={"=QtyOrd=QtyShip AND ShipDate<=PromiseDate"}>} OrderNumber)/Count(DISTINCT OrderNumber), OrderNumber))
May be this?
= FirstSortedValue(Whse_Name, -Aggr(Count(DISTINCT {<%Order={"=QtyOrd=QtyShip AND ShipDate<=PromiseDate"}>} OrderNumber)/Count(DISTINCT OrderNumber), OrderNumber))