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.