1 Reply Latest reply: Feb 26, 2010 7:41 PM by Vlad Gutkovsky RSS

    % in Pivot Table

    Eduardo Garcez

      Hi!, I´m trying to calculate the percentile value of an variable (expense) in function of another variable (revenues) in one same dimension (count).

      I have tried many different ways to solve problem, without sucess

      If possible to make the percentage in function of the ID (ID=1, 500)

       

      ID count value change% (objective)

      1 revenues 500 =500/500

      2 expenses 50 =50/500