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.
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).
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.
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.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein