2 Replies Latest reply: Nov 27, 2012 9:25 AM by Cosmin Cirnu RSS

    pivot table - calculate share correctly

    Cosmin Cirnu

      hi all,

      i have a pivot table with 2 dimension - Year & salesman and i want to see share of sales (year by year) between the salesmen; the problem is when i sellect just a salesman, or less than all of them because share becomes 100%; if i put {1} in formula is not ok because it calculates and solves share for each salesman even i select just one of them but is wrong when i want these situation not for all product and i select just one, or two

      also, in reality i have a cyclic Year/Month and i want a formula ok for both situation

      i attached the document

       

      Thanks,

      Cosmin