none
TopCount in the Connection Formula dialog box to a scorecard row is not evaulated at current context RRS feed

  • Question

  • Hi,

    I am using the following statement in Connection Formula dialog box of my filter to a scorecard to populate scorecard rows dynamically based on my Manufacturer selection from the filter .

    TopCount(

    {Descendants(<<UniqueName>>,2)}, 10,

    sum ([Date].[Date].CurrentMember.lag(90):[Date].[Date].CurrentMember, [Measures].[Sales amount USD])

    )

                    

    I cannot get desired rows returned. The statement fails to be evaluated at current time period, it always returns the top 10 of all time period.

    Any solution please?

    Thanks


    hyang


    hyang

    Friday, July 6, 2012 9:49 PM

All replies