1 Reply Latest reply on Apr 17, 2018 3:33 PM by Patrick A Van Der Hyde

    Quick help

    Niranjan Banarjee

      HI,

       

      I want to get a row with the number 2.7 as shown under Total to be shown under rest Category.Please help

       

      The formula i used for Vol= Current Growth (Category driver)=

      ((sum({ FIXED [Select Country],[Prod Category Descr]:

      sum(IF [Brand Owner Descr (group)]=[Company] THEN [C Volume] else 0 END)})/

      sum({ FIXED [Select Country],[Prod Category Descr]:

      sum(IF [Brand Owner Descr (group)]=[Company] THEN [P Volume] else 0 END)}))-1)*100

       

       

        

      TotalCat-1Cat-2Cat-3Cat-4Cat-5Cat-6Cat-7Cat-8Cat-9Cat-10
      Vol-Current Growth (category driver)2.726.22.626.212.7