4 Replies Latest reply: Jan 26, 2018 8:43 AM by vikas mahajan RSS

    How to use getfieldSelection in Aggr

    vikas mahajan

      Hi all,

       

      With reference to discussion based on the link  Market Share Calculation Month Wise Market Share Calculation in QS .

       

      I have multiple dimension in my pivot chart where as  I wanted to calculate market share based on many parameters

       

      Like Company,Region1,RegionName,StateName,Territory  etc

       

       

      Sum ([CY Sale])/aggr(nodistinct Sum ({<[Company]=>}[CY Sale]),MonthName)

       

      So i want to use getfieldselection  dynamically when user will select  Company  then company wise market share will be calculated if user select Region1 then I should get Region1 wise MS.

       

      Thanks

       

      Vikas