4 Replies Latest reply: Apr 26, 2018 10:16 PM by Reynaldson Aceberos RSS

    Pivot Table Distribution Computation

    Reynaldson Aceberos

      Hi Guys i have a challenge in computing the distribution in pivot table

       

      im trying to compute the distribution rate from header to detailed but i always got wrong answer...

       

      the GRAND TOTAL NET SALES(RETAIL+WHOLESALES) is okay coz if  but the GLDesc dont have any values to compute

      it must compute

       

      ex.

           Sales Concession Retail Fresh       3,737.00 / 32,062,031  so on....

       

       

      thanks for the help

       

      Distributionv2.JPG