2 Replies Latest reply: Mar 2, 2012 9:32 AM by iusprezgarca RSS

    Rank or counter in a chart with 2 sorting dimensions...


      We've a problem using rowno(TOTAL) when sorting by 2 dimensions.

      We've a chart with the sales to our costumers with 2 dimensions; sum(sales) and count(costumer) to get the total amount of sales and the number of tickets.

      As you can see, we can sort the char firstly descending by number of tickets and then ascending by total of sales without any problem.

      However, our users need a counter so we've tried to use rowno(TOTAL) function.

      When we add this new field, as you can see in the chart, suddenly, we loose sorting...

      What function could we use to make a ranking or counter using two ordering dimensions?.