Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Could you please correct the below Set Analysis expression.
only({<URL={"=Rank(Sum(Sales),4,2)=1"}>})
you are missing the field that ONLY() should be returning
only({<URL={"=Rank(Sum(Sales),4,2)=1"}>} RETURNfield )
Sir,
Could you please help me, i am in deep trouble.
i want the image of the Maximum sales for each Style, in this case
Image5 for NY30 and Image2 for NY50.
Could you please help, i tried with FirstSorted this was giving Nested Aggregation as i am using this in another expression.
i tried with
only({<URL={"=Aggr(Rank(Sum(Sales),4,2),Style,Item)=1"}>}URL) , but was not giving the correct result,
Any help Sir, please kindly help