none
Show dates in descending order in grid/dashboard RRS feed

  • Question

  • In the way of an example I have the grid below and I would like to display the dates in reverse order, i.e. most recent date at the top/descending order.

    I have tried the MDX formula 'ORDER(<<UniqueName>>, <<UniqueName>>.MEMBER_KEY, DESC)' in the bit where you bind a filter to the grid chart in a dashboard, but it does not appear to change the order.  

    Any ideas?

    P.S. I am using SharePoint 2010 and PerformancePoint Services in there.


    Mo

    Wednesday, July 25, 2012 10:13 AM

All replies

  • Try using:

    { ORDER([dim Date].[Date Hierachy], <<UniqueName>>.MEMBER_KEY, DESC) }

    Use your date dimension as the first parameter rather than member.

    http://dailyitsolutions.blogspot.com/

    Wednesday, July 25, 2012 2:49 PM
  • Try below

    ORDER([Recent Date].[Fiscal Hierarchy],[Recent Date].[Fiscal Hierarchy].CurrentMember.Properties('KEY0'),DESC)


    Nanda

    Saturday, August 4, 2012 7:39 AM