none
Sorting by data field in a matix report RRS feed

  • Question

  • I have a report like :
    Customer                          year 1                     year 2                  year 3
                                  imported   manual    imported  manual    imported   manual

    ABC                         10                  5             2           1            3             50
    DEF                           3                   0            49          0            9             30 
    GHI                           1                 500         200         5000        1            10 
    and I am trying to export the report in excel with data sorted by data field (which is  sum of count of orders) in the last year (year 3) for manual ( as shown above: 50, 30, 10,    ) in descending order.
    Please note that the year field is dynamic and it will always be last completed year. I have already created the report but having difficulty in getting the required sorting. Any help will be highly appreciated.
    Thursday, March 18, 2010 4:50 PM