4 Replies Latest reply: Nov 7, 2012 12:22 AM by kittukita RSS

    Set Analysis Problem

      Hi experts,

       

      I have been facing a problem in using set analysis for one my set analysis.

       

      Selections available for users: Year, Quarter, Month, Week, Region, Country

       

      What I would like to calculate? - Cost for current week i.e. Maximum week for a particular region or country. I do not want the selections made by the user in Year, Quarter, Month and Week to have any effect on this.

       

      Formula used:     sum({$<Year=,Quarter=,Month=,Week={$(=Max(Week))}>}Cost)

       

      Somehow, this is not negating the selection made by user in Quarter or Month or Week.

       

      Please find the example file I created for reference.

       

      Any help would be appreciated!

       

      Thanks,

      Kiran