I need to display top 50 sales records. I’m using Rank function in Slice and Dice panel. Is it the only way to get topmost records or do i need to write SQL query for that? Is it possible without SQL query Thanks in advance?
Thanks Steve. Actually, i have 6 crosstabs in my report and i’m showing data for each measure for 12 months. So i have 3 dimensions and 1 measure in each of those crosstabs. Dimensions are Code_Number, Issue_Name and Month/yr. Measures are sales, profit… I have to rank top 50 Issue_Names for each month(i.e sorted in desc order on month)
Now when i’m applying Rank function through slice and dice panel, i dont get sorted results.
My rank function is Rank(, ). What could be wrong?
Actually… I thought the ranking overrode all Filters and Sorts. That means that it automatically sorts in descending order based on the Ranked Measure.
I think I’ve used a technique to use some “multipliers” to a measure to adjust my sorting the way I wanted it, but displayed the original measure in the report.
(Like using -100000 and grabbing the bottom (not top) values), or using IF THEN ELSE to add XXX amount based on the order I would prefer them in… of course the XXX amount had to be larger than the values ranked.