Rank multiple dimensions?

[devarasu07]

Hi All,

Tried like below expression as Calculated dimension and it's giving correct. do you have any idea to resolve it? Thanks

=aggr(rank(sum(SoldQty),4),Launch_No,CurrentSellingPrice,ArticleNo)

[tresesco]

Could you explain more on expected output?

[devarasu07]

Hi,

The report is to allows store to ensure all stocks are display as per the sequence;

1) Launch_No,  (Is number (one launch can have many article with selling price)

2) current Selling Price (desc order)  ---> Is the Price value from dimension

3)  Sold Qty (high to low) by ArticleNo

Note:

1) Sub total of every article sold

2) Rank with one dimension is working fine but we need to show the report based on the above order sequence.

I've tried below expressions,

=aggr(NODISTINCT rank(TOTAL sum(SoldQty),4) Launch_No,CurrentSellingPrice, ArticleNo)

//=aggr(Rank(sum(SoldQty),4),Launch_No,Original_Selling_price,ArticleNo)

//=Max( aggr ( sum(SoldQty) , CurrentSellingPrice, ArticleNo ) )

//=aggr(rank(sum(SoldQty),4),ArticleNo,CurrentSellingPrice)

Thanks,

Deva

[sunny_talwar]

What are the numbers you are expecting to see?