8 Replies Latest reply: Oct 24, 2016 12:22 PM by Elina Vergara RSS

    %Mix

    Elina Vergara

      Hello, i have a pivot table where i need to present %mix, but i have a dimensión Region , some like this, my problem is when i use the expression Sum(TOTAL Aggr(sum({<$(vSetYearAct),$(TipRegion)>}#Sales),CanalName)) for get sum of sales for region show sales for noth and south, not separate

       

       

       

       

      RegionNortSouth
      Canal NameSales%MixSales%Mix
      Canal 1547233%871252%
      Canal 2876952%647839%
      Canal 3254715%214513%
      Total16788100%17335103%