1 2 Previous Next 23 Replies Latest reply on Aug 15, 2017 6:42 PM by Shinichiro Murakami

    Rank  Time Dimension by current year by Calculated Fields(with Table Calculations)

    Indre White

      Hi all,

       

      I am having a problem ranking only partial dimension while showing all. I want to show all years, but rank only most current year, most current quarter, etc . so I am showing variances per specialty cost.

      Variances are part of table calculations. Now, I created Top N parameter to show TOP N , and then bottom N based on variance only for current year ( 2017). I still want to show all years, but only rank 2017 ( and select TOP N based on 2017 data).

      then I want to show it also Quarterly comparison starting most current complete quarter of most current year. And select TOP N and bottom N.

      What is best approach to this?

       

      thank you so much!

       

        1 2 Previous Next