I am showing top 20 clients in a straight table containing only two columns, client names and their repective sale. I want to show serial number in this straigh table that is starting from 1 to 20. I tried using Rowno() but I can only use it in expression so I cant bring Rowno() before the client name also as I said I want to show top 20 clients only so using rowno() I'm not getting the right top 20 clients as the table is sorted according to sales numbers.
Is there any way to add serial number in this straight table so that I can have 3 columns. Very first column will be SerialNo, then Client and and lastly the sales values.
You cannot pivot a straight table, but you do can move the expressions and dimensions holding the click on the corresponding column until the blue arrow shows up, then move it to the first place. That should work.
I had a similar problem but with more dimensions and expressions in one straigth table and was getting mad with the rowno() screwing up my desired sorting. Finally the rank() function was solving my issue. Just use rank(your aggregation expression), for turning around the ranking: rank(1/your aggregation function).
As an option that you can use, =FirstSortedValue(client, -sales) , if you do not know what this will do it will return the 'client' field data, based on the highest sales. If you wanted to get the next one it would be =FirstSortedValue(client - 1, -sales). If you were to put this into a loop based on the row of the table you are creating it could work.
Hi, I am facing same problem. I have a straight table with 2 dimensions and 8 expressions with set analysis formula. I have added sort based on one of the expression but when i add Rowno(Total) it affect my sort order. I am sorting top 20 client based on revenue. Thank you..
.png "Miguel_Angel_Baeyens"){kind=avatar}
