Rank function not to consider OTHER and TOTAL

[#1]

Hi,

I have a straight chart table having rank function, but it is showing rank including OTHER and TOTAL as well. But I don't want to consider these two while ranking.

I just used Rank(Measure).

How to avoid OTHER and TOTAL?

Thanks,

[Kushal_Chawda]

Please find the attached one.

Is it what you are looking for? !

[#3]

I want both OTHER and TOTAL should be displayed without considering rank. Rank should apply only for weekdate and SoldAmt, shouldn't consider OTHER and TOTAL.

Thanks,

[Kushal_Chawda]

Dear Madu,

Please look into the solution that I have attached before

[ecolomer]

OK, This?

[#6]

I am using personal edition, not able to open.

Thanks,

[Kushal_Chawda]

Please follow the below steps

1) Take a dimension as WeekDate

2) Do the settings in Dimension limit tab as required

3) Take 1st Expression as Sum(SoldAmt)

4) Take 2nd Expression as aggr(rank(sum(SoldAmt),4),WeekDate)

5) Sort Chart by 2nd Expression

[ecolomer]

Here you have an image

You can see it?