Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear ,
This is my set Expression
=count({<[Date Stamp] ={">=$(=Date(Today()-90,'DD-MM-YYYY'))<=$(=Date(today(),'DD-MM-YYYY'))"}>}[Color Priority])
for total no. of colour instances i have to show top 10 .
i used this expression
=Aggr(Rank(count({<[Date Stamp] ={">=$(=Date(Today()-90,'DD-MM-YYYY'))<=$(=Date(today(),'DD-MM-YYYY'))"}>}[Color Priority])) <=10,[Color Priority])
Its not working . Please Suggest.
Have you tried this?
IF(Aggr(Rank(count({<[Date Stamp] ={">=$(=Date(Today()-90,'DD-MM-YYYY'))<=$(=Date(today(),'DD-MM-YYYY'))"}>}[Color Priority])),[SKU Code],[Color Priority]) <=10,count({<[Date Stamp] ={">=$(=Date(Today()-90,'DD-MM-YYYY'))<=$(=Date(today(),'DD-MM-YYYY'))"}>}[Color Priority]))
Yes , this is not limiting to top 10 .
@Aanchal Try this
IF(RANK( Count(Aggr(Count([Color Priority])),[SKU Code]))<=10,Count([Color Priority]))
This instead
IF(RANK(Count(aggr(Count([Color Priority]),[SKU Code],[Color Priority])))<=10,Count([Color Priority]))
No, not working.