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



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



      thanks for the help