3 Replies Latest reply: Mar 19, 2018 11:00 AM by Reporte Gestão RSS

    pivot measure divide current sum for sales sum

    Reporte Gestão

      Hello, i'm trying to calculate the sum values over the sum of sales. So far i managed to divide it properly but only on totals, som how it doesn't assume the collumn filter. It must be missing something in my formula.

      if(isnull(Sum(CBL_ValorT)) or Sum(CBL_ValorT)=0, 0, num(fabs(Sum(CBL_ValorT))/Sum({<Group1={"0.*"}>}CBL_ValorT),  '#.##0,0%'))

      it's returning this,

      shopdetail.jpg

      but it should return this.

      shopgoal.jpg

       

      i know this is because is dividing over the total and not over the column, but i can't get to it.

      totals.jpg

      thks in advance.