Interactive Sorting on Matrix Report RRS feed

  • Question

  • I have a  matrix report that looks similar to the following.  It sums all the sales for products by each month a displays them in a matrix table.   I want to be able to put an interactive sort on the columns so that a user can select Oct2008 and the report will sort all the sales in descending order for the month of October.  Is this possible?  I have seen other solutions that recommend putting the sort in the corner cell, but this just causes the report to sort all the columns, not for a specific month.  Any help would be greatly appreciated!

    Jul 2008 Aug 2008 Sept 2008 Oct 2008
    Product1 50 75 150 20
    Product2 150 57 14 84
    Product3 530 65 62 76
    Product4 30 23 45 51
    Friday, September 26, 2008 6:28 PM

All replies