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,

[ecolomer]

can you explain more or upload an simple data?

[#3]

include the data

[Kushal_Chawda]

Can you please provide sample data & Output needed for the same?

[ecolomer]

no datafile

[#6]

Sorry for the delay as it is festive season in INDIA, here you go.

I am creating straight chart table with Weekdate,SUM(SoldAmt) and Rank(SUM(SoldAmt)). Dimension limit is 6 and I have enabled options Show Others and Totals, but Rank is displaying 1 for TOTAL and 2 for OTHER. Selected dates are 12/9/2013, 5/9/2014, 5/26/2014, 6/9/2014, 6/16/2014

I am using personal edition, please let me know if you need further details.

Thanks

[sorrakis01]

Hi,

Can you upload an image of your table?

[#8]

Pls find the attached qvw file.

Thanks,

[ecolomer]

Is this you need?

[ecolomer]

If you can't open my file, the expression is:

=IF(Aggr(Rank(SUM(SoldAmt),4),WeekDate)<=5,WeekDate)