Last 10 Items!

[#1]

Hi All,

Using the below I used to find the Top 10 ranking items along with this FSName is also there in the dimension field which is used to display the FSName. In the expression field I used Sum(Value) to show the value of the Top 10 items.

Same thing I want to do for the Last 10 items. Don't know exactly what changes I have to do in the below script. Can some one please help me out to do the same.

=IF(
aggr(
rank(total
aggr( sum(Value),FSName)
,0,1)
,FSName)
<=10,

aggr(
rank(total
aggr( sum(Value),FSName)
,0,1)
,
FSName))

[johnw]

Just change the sign: -sum(Value)

[#3]

Hi John,

I already tried with that. In that case it shows only the -ve value. It is not showing up the positive values. In my application sales value contain both +ve as well as -ve values.

Have attached the actual and expected result below.

Actual:

Expected:

[#4]

Hi John,

What is the use of -ve sign before Sum(Value). First of all I thought it sort the value from lowest to highest. Later when checked realized that it doesn't do that. So could you please for what purpose we are putting -ve sign before Sum(Value).

Thanks in advance

[johnw]

Please post an example with the problem, then. As should be obvious, flipping the sign will reverse the rankings. And unless there's a bug I'm not aware of, reversing the ranking by flipping the sign should not prevent positive values from showing.

[#6]

Hi John,

Thanks for explaining me the use of -ve sign before sum. By the way as requested I have attached the document for you to work with. Hope the issue will be understandable now.

[jonathandienst]

Rikab

If you turn off the suppress zero value option in the Presentation tab of your Last 10 FS's and your Sales Value for Reference tables, you will see that there are a number of FSNames with value of zero. These all tie for 3rd place when ranking the bottom 10.

That explains why you only see two when zeroes are suppressed.

Jonathan